TD_DAY_OF_WEEK_COMPATIBLE_UDF
Definition
Process the day of the week a timestamp belongs to. It has the same behavior as the DAYNUMBER_OF_WEEK(DATE, 'COMPATIBLE') function.
Parameters
INPUT TIMESTAMP_TZ
The date to get the day of the week from.
Returns
Returns an integer between 1 and 7 where if January first is Wednesday then, 1 equals Wednesday, 2 equals Thursday... 7 equals Tuesday, and so on.
Usage example
Input:
Output:
Last updated