DAY_OF_WEEK
Returns the ISO day of the week from timestamp. values range from 1 (Monday) to 7 (Sunday).
Syntax
Arguments
Name | Type | Description | Default Value |
---|---|---|---|
timestamp | timestamp |
Returns
bigint
Examples
timestamp | Output |
---|---|
timestamp '2018-03-10 08:55:12.456' | 6 |
Transformation job example
SQL
Query result
timestamp | Output |
---|---|
timestamp '2018-03-10 08:55:12.456' | 6 |
Last updated