Date & Times
A timestamp is a sequence of characters or encoded information identifying when a certain event occurred.
Xano stores timestamps as a unix timestamp in milliseconds. Unix timestamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC.
For example: 1604959474 seconds since Jan 01 1970. (UTC). This epoch translates to 11/09/2020 @ 10:04pm (UTC). Since Xano uses milliseconds, the timestamp would be 1604959474000.
There is no timezone in a timestamp because it is the number of milliseconds from the unix epoch - Jan 1, 1970.
A timezone region handles daylight savings time for you. For example: America/Los_Angeles will automatically be PST or PDT depending on the actual timestamp. It handles this behind the scenes so you always have the right timezone offset. Timezone regions are listed here.
A timezone abbreviation is the shortened 3 letter abbreviation (PST, PDT, etc.). This represents a timezone offset: PST is -0800 and PDT is -0700. These values are always the same. It is recommended to use the timezone region mentioned above so you don’t need to keep changing the abbreviation selection with daylight savings time changes.
The database table view is using the unix timestamp internally but transforming it in the spreadsheet view to the timezone of your browser. This means that if someone else was looking at it from a different timezone, they would see the time that is local to themselves. However, you can change the browser default settings to your preferences for the date & time format and timezone offset that is shown in your database on the account page.
- Raw timestamp in milliseconds (this would not need any timezone information). For example: 1604959474000
- ISO 8601 format, which is Year-Month-Day then a “T” and then 24hour-minute-second then “the timezone offset in hours and minutes”:2004-02-12T15:19:21+00:00
- Postgres database format, which is similar to the ISO 8601 format: 2020-11-09 14:13:18-0800 (Note: a space is used to separate the date from the time instead of the “T” character in ISO 8601. Also, the offset does not include the colon.)
- Relative time. Xano uses relative time formats from php.net. For example: now, last Monday, +7 days, etc. (Relative times normally don’t have any timezone information, so it will often be important to reference the timezone in any type of filter.)
Here are relative time formats and their meanings that Xano accepts (source: php.net).
- Parse Timestamp the parse_timestamp filter allows you to take a human-readable time format and parse it into a Unix timestamp in milliseconds to be stored in the Xano database. The characters used are the same as formatting date and time and can be found here from php.net.
There are lots of options available. A full list is available here from php.net. Here are a just few examples:
- c = 2004-02-12T15:19:21+00:00
- r = Thu, 21 Dec 2000 16:01:07 +0200
- Y-m-d H:i:s = 2000-01-01 00:00:00