year()

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

Syntax

year ( bigdatetime [ ,timezone ] )

Parameters

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.

Usage

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

Example

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