DayOfMonth

DayOfMonth( timestamp )
DayOfMonth( timestamp )
DayOfMonth( timestamp )
DayOfMonth( timestamp )
day_of_month( timestamp )
DayOfMonth( timestamp )

Description

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

Parameters

Argument Type Definition and Requirements

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 query below returns the day of the month from a timestamp:

client.Query(DayOfMonth(Time("2019-04-29T12:51:17Z")));
29
curl https://db.fauna.com/ \
    -u fnAChGwBcAACAO70ziE0cfROosNJHdgBmJU1PgpL: \
    -d '{ "day_of_month": { "time": "2019-04-29T12:51:17Z" } }'
HTTP/1.1 200 OK
{ "resource": 29 }
result, _ := client.Query(f.DayOfMonth(f.Time("2019-04-29T12:51:17Z")))
fmt.Println(result)
29
System.out.println(
    client.query(
        DayOfMonth(Time(Value("2019-04-29T12:51:17Z")))
    ).get()
);
29
client.query(
  q.DayOfMonth(q.Time('2019-04-29T12:51:17Z'))
)
.then((ret) => console.log(ret))
29
result = client.query(q.day_of_month(q.time("2019-04-29T12:51:17Z")))
print(result)
29
println(Await.result(
  client.query(DayOfMonth(Time("2019-04-29T12:51:17Z"))),
  5.seconds
))
29

Was this article helpful?

We're sorry to hear that.
Tell us how we can improve!
Visit Fauna's Discourse forums or email docs@fauna.com

Thank you for your feedback!