Month

Month( timestamp )
Month( timestamp )
Month( timestamp )
Month( timestamp )
month( timestamp )
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:

try
{
    Value result = await client.Query(
        Month(Time("2019-04-29T12:51:17Z"))
    );
    Console.WriteLine(result);
}
catch (Exception e)
{
    Console.WriteLine($"ERROR: {e.Message}");
}
LongV(4)
result, err := client.Query(
	f.Month(f.Time("2019-04-29T12:51:17Z")))

if err != nil {
	fmt.Fprintln(os.Stderr, err)
} else {
	fmt.Println(result)
}
4
System.out.println(
    client.query(
        Month(Time(Value("2019-04-29T12:51:17Z")))
    ).get()
);
4
client.query(
  q.Month(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,
))
4
result = client.query(
  q.month(q.time("2019-04-29T12:51:17Z"))
)
print(result)
4
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

Is this article helpful? 

Tell Fauna how the article can be improved:
 Visit Fauna's forums or email docs@fauna.com

Thank you for your feedback!