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.

 
DayOfMonth( timestamp )
day_of_month( timestamp )
DayOfMonth( timestamp )
DayOfMonth( timestamp )
DayOfMonth( timestamp )
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:

client.query(
  q.DayOfMonth(q.Time('2019-04-29T12:51:17Z'))
)
.then((ret) => console.log(ret))
.catch((err) => console.error(
  'Error: [%s] %s: %s',
  err.name,
  err.message,
  err.errors()[0].description,
))
29
result = client.query(
  q.day_of_month(q.time("2019-04-29T12:51:17Z"))
)
print(result)
29
result, err := client.Query(
	f.DayOfMonth(f.Time("2019-04-29T12:51:17Z")))

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}
29
try
{
    Value result = await client.Query(
        DayOfMonth(Time("2019-04-29T12:51:17Z"))
    );
    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}
LongV(29)
System.out.println(
    client.query(
        DayOfMonth(Time(Value("2019-04-29T12:51:17Z")))
    ).get()
);
29
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

\