MAXDATE returns a character string containing the latest date/time value corresponding to a specified date/time pattern.
MAXDATE('YYYY-MM-DD-HH.MI.SS.999999') returns the value '9999-12-31-23.59.59.999999'.
>>-MAXDATE(p)--------------------------------------------------><
- p
- Specifies one of the supported date/time patterns.
The allowed date/time patterns are listed in Table 2.