Scalar. Returns the integer representing the day of the week (Sunday is 1) extracted from a given bigdatetime.
dayofweek ( bigdatetime [ ,timezone ] )
| bigdatetime | A bigdatetime value. |
| timezone | (Optional) A string representing a valid time zone. If none is specified, UTC is used. See "Time Zones" and "List of Time Zones" for more information. |
Returns an integer representing the day of the week extracted from a given bigdatetime. The function takes a bigdatetime as its argument (and an optional string representing a time zone), and the function returns an integer. Sunday is represented by 1, and the rest of the days of the week follow.
dayofweek ((unbigdatetime ('2010-03-03 12:34:34:059111')) returns 4.