Xano Documentation
Search…
⌃K

Timestamp Filters

A timestamp is a sequence of characters or encoded information identifying when a certain event occurred.
For information on how Xano stores, reads, and formats timestamps visit the Timestamp page.
to_timestamp: In this example, the timezone UTC is important because 'last Monday' means different things depending on timezone. It's important to specify a timezone for 'last Monday' because it could 'last Monday' at 00:00:00 PST is different than 'last Monday at 00:00:00 UTC (or any other timezone). Xano stores it in Unix timestamps which is a specific number in milliseconds.
However, if the timezone was present like in this example, then the timezone would not have any effect. In this example 'now' would be the same Unix timestamp, regardless of timezone. Therefore, a specified timezone like UTC, is not necessary.
add_ms_to_timestamp: Add milliseconds to a timestamp, (negative values are ok).
This filter will change the timestamp from 1593046644 to 1593546644.
add_secs_to_timestamp: Add seconds to a timestamp, (negative values are ok).
This filter will change the timestamp from 1593046644 to 1593546644.
format_timestamp: Converts a timestamp into a human-readable formatted date based on the supplied format. This format follows this PHP DateTime format list. M is month like Jul, Y is year, etc. Timezone regions are listed here.
The “r” format displays the entire date including timezone offset. America/Los_Angeles timezone will have an offset for that timezone. The result would look like: Mon, 09 Nov 2020 17:28:05 -0800
This filter will convert the Unix timestamp to 2020-07-02 16:14:25 using the Y-m-d H:i:s format.
parse_timestamp: Parse a timestamp from a flexible, human-readable format into a Unix timestamp in milliseconds. This filter is sort of like the opposite of format_timestamp. You can utilize the PHP DateTime Format character list to transform a time format into a Unix timestamp in milliseconds.
In this example, May 4th, 2020 is transformed into a timestamp.
Parse format for May 4th, 2020
F jS, Y
30/03/2024 14:30:00 is parsed into a Unix timestamp in milliseconds
Parse format for 30/03/2024 14:30:00
d/m/Y H:i:s
11-27-22 5:15PM is parsed into a Unix timestamp in milliseconds.
Parse format for 11-27-22 5:15PM
m-d-y g:iA
6/1/22 07:30:00 am will be parsed into a Unix timestamp in milliseconds.
Parse format for 6/1/22 07:30:00 am
n/j/y h:i:s a
transform_timestamp: This allows you to use relative time formats that are anchored around a previous time. Use the link to see various relative time formats that Xano accepts.
This example is saying last Monday of PST, at the start of the day (00:00:00)