function - How do you obtain the maximum possible date in Oracle?

Question

Is there a function built into Oracle that will return the highest possible date that may be inserted into a date field?

Answer 1

SELECT  TO_DATE('31.12.9999 23:59:59', 'dd.mm.yyyy hh24:mi:ss')
FROM    dual

Note that minimal date is much more simple:

SELECT  TO_DATE(1, 'J')
FROM    dual