Reference material for DATE function
Converts a TIMESTAMP
, TIMESTAMPTZ
, DATE
, or TEXT
value to a DATE
value. If the conversion cannot be performed, the DATE
function raises an error.
Parameter | Description |
---|---|
<expression> | The expression that should be converted to a DATE . |
The DATE
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.
The following code example converts the TEXT
value 1990-01-01
to a DATE
value representing that date:
Returns
Reference material for DATE function
Converts a TIMESTAMP
, TIMESTAMPTZ
, DATE
, or TEXT
value to a DATE
value. If the conversion cannot be performed, the DATE
function raises an error.
Parameter | Description |
---|---|
<expression> | The expression that should be converted to a DATE . |
The DATE
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.
The following code example converts the TEXT
value 1990-01-01
to a DATE
value representing that date:
Returns