Scalar. Returns the integer representing the day of the year extracted from a given bigdatetime.
dayofyear ( 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 year 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.
dayofyear ((unbigdatetime ('2010-03-03 12:34:34:059111')) returns 62.