The schema is SYSIBM.
The DATE function returns a date from a value.
The argument must be a DATE, TIMESTAMP, a positive number less than or equal to 3 652 059, a valid string representation of a date or timestamp, or a string of length 7 that is not a CLOB or DBCLOB.
Only Unicode databases support an argument that is a graphic string representation of a date or a timestamp. In a Unicode database, if a supplied argument is a graphic string, it is first converted to a character string before the function is executed.
If the argument is a string of length 7, it must represent a valid date in the form yyyynnn, where yyyy are digits denoting a year, and nnn are digits between 001 and 366, denoting a day of that year.
The result of the function is a DATE. If the argument can be null, the result can be null; if the argument is null, the result is the null value.
DATE(RECEIVED)
DATE('1988-12-25')
DATE('25.12.1988')
DATE(35)