gsql_year()

Returns 4-digit year from timestamp.

The timestamp parameter should be in one of the following formats:

  • "%Y-%m-%d %H:%M:%S"

  • "%Y/%m/%d %H:%M:%S"

  • "%Y-%m-%dT%H:%M:%S.000z"

    • Text after the dot . is ignored

%Y is a four-digit year. %m is the month number between 1 and 12. %d is the day number between 1 and 31.

Syntax

gsql_year(timestamp)

Parameters

timestamp

Required. A timestamp.

Return type

INT

Example

gsql_year("2013-05-09 23:56:52") -> 2013