TIMESTAMP, TIMESTAMPTZ, DATE, or TEXT value to a DATE value. If the conversion cannot be performed, the DATE function raises an error.
Syntax
Aliases
Parameters
Return Type
TheDATE function returns a result of type DATE. If the conversion cannot be performed, the DATE function raises an error. For more information on conversion rules, check out the documentation of the DATE data type.
Example
The following code example converts theTEXT value 1990-01-01 to a DATE value representing that date:
Rows: 1Execution time: 5.58ms