hour()

Scalar. Returns an integer representing the hour extracted from a given bigdatetime.

Syntax

hour ( bigdatetime [ ,timezone ] )

Parameters

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.

Usage

Returns an integer representing the hour 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.

Example

hour ((unbigdatetime ('2010-03-03 12:34:34:059111')) returns 12.