DATE
Converts the input value to a DATE
data type.
Behavior Type
- Immutable if the input value is a
TIMESTAMP
,DATE
,VARCHAR
, or integer - Stable if the input value is a
TIMESTAMPTZ
Syntax
DATE ( value )
Parameters
value |
The value to convert, one of the following:
|
Examples
=> SELECT DATE (1); DATE ------------ 0001-01-01 (1 row) => SELECT DATE (734260); DATE ------------ 2011-05-03 (1 row) => SELECT DATE('TODAY'); DATE ------------ 2016-12-07 (1 row)