Month

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.
Copied!
Month( timestamp )

Description

The Month function extracts the month from a Timestamp.

Parameters

Parameter Type Definition and Requirements

timestamp

Timestamp

A timestamp.

Returns

A Number which represents the value of the month, in the range 1 to 12, from the provided Timestamp.

Examples

The following query returns the month from a timestamp:

Copied!
Month(Time('2019-04-29T12:51:17Z'))
4
Query metrics:

  •    bytesIn:  41

  •   bytesOut:  14

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 3ms

  •    retries:   0

\