Returns a date from a value. The argument must be a timestamp, a date, a positive number less than or equal to 3652059, a valid string representation of a date, or a character string of length 7.
Example:
Assume that the column RECEIVED (timestamp) has an internal value equivalent to '1988-12-25 - 12.30.000000'.
DATE(RECEIVED)
Results in an internal representation of '1988-12-25'.