The Fauna service will be ending on May 30, 2025.

For more information on the service wind down, see our announcement and the Fauna Service End-of-Life FAQ.

DayOfMonth

This reference topic applies to FQL v4. Go to this page for the latest FQL v10 reference topics.

Copied!
DayOfMonth( timestamp )

Description

The DayOfMonth function extracts the day of the month from a Timestamp.

Parameters

Parameter Type Definition and Requirements

timestamp

Timestamp

A timestamp.

Returns

A Number which represents the value of the day of the month, in the range 1 to 31, from the provided timestamp.

Examples

The following query returns the day of the month from a timestamp:

Copied!
DayOfMonth(Time('2019-04-29T12:51:17Z'))
29
Query metrics:
  •    bytesIn:  48

  •   bytesOut:  15

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 1ms

  •    retries:   0

\