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