Scalar. Returns an integer representing the seconds extracted from a given bigdatetime.
second ( bigdatetime [ ,timezone ] )
bigdatetime | A bigdatetime value. |
timezone | (Optional) A string representing the 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 seconds 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. If either argument is NULL, the function returns NULL.
second ((unbigdatetime ('2010-03-03 12:34:34:059111')) returns 34.