DATE
Casts a string value to a date.
Syntax
Arguments
Name | Type | Description | Default Value |
---|---|---|---|
value | string |
Returns
Returns a date
value.
Examples
value | Output |
---|---|
'2022-02-01' | date '2022-02-01' |
timestamp '2022-02-01 00:00:00' | date '2022-02-01' |
timestamp '2022-01-01 00:30:00' | date '2022-01-01' |
Transformation job example
SQL
Query result
value | Output |
---|---|
'2022-02-01' | date '2022-02-01' |
Last updated