Time and Date functions

Fauna has two special data types dealing with dates and times. The first data type is date which stores a calendar date. The second is a timestamp (ts) which stores an instant in time expressed as a calendar date and time of day. Timestamp can safely store nanoseconds precision, but be careful as many operating system clocks provide only microsecond precision. All Timestamps are stored in UTC. If a timestamp is inserted with a timezone (TZ), it is converted to UTC and the local timezone is not stored. The following functions allow the manipulation of dates and timestamps.

Was this article helpful?

We're sorry to hear that.
Tell us how we can improve! documentation@fauna.com

Thank you for your feedback!