Time

Copied!
( str )

Description

The Time function constructs a Timestamp, either from the string now, or from an ISO 8601 string.

The special string now may be used to construct a time from the transaction’s start time. Multiple references to now within the same transaction produce the same timestamp. During a temporal query, now still means the transaction’s start time, not the temporal query’s specified timestamp.

Use of now is deprecated. Use Now instead.

ISO 8601 times

Time uses Java’s Date/Time API which understands a subset of the ISO 8601 standard. Not all time strings that are ISO 8601-compliant can be parsed.

The template for times is yyyy-MM-ddThh:mm:ssTZO, where:

  • yyyy represents the year

  • MM represents the month, from 00 to 12

  • dd represents the day, from 00 to 31

  • T is a separator between the date and time

  • hh represents the hours, from 00 to 23

  • mm represents the minutes, from 00 to 59

  • ss represents the seconds, from 00 to 59

  • TZO is the timezone offset from GMT, which can be:

    • Z for GMT (no offset)

    • +hhmm for a positive hour and minute offset from GMT

    • -hhmm for a negative hour and minute offset from GMT

The seconds can also be expressed as a decimal fraction, which provides down to nanosecond resolution.

Parameters

Parameter Type Definition and Requirements

str

String

The String now, or an ISO 8601 date/time formatted string.

Returns

A Timestamp based on the value of str.

Examples

The following query returns a Timestamp constructed from the provided string:

Copied!
('1970-01-01T00:00:00+00:00')
("1970-01-01T00:00:00Z")
Query metrics:

  •    bytesIn:  36

  •   bytesOut:  43

  • computeOps:   1

  •    readOps:   0

  •   writeOps:   0

  •  readBytes:   0

  • writeBytes:   0

  •  queryTime: 3ms

  •    retries:   0

Wikipedia ISO 8601

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!