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.


In this example, the timezone UTC is important because 'last Monday' means different things depending on timezone.

t'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 milliseconds to a timestamp, (negative values are ok).


Add seconds to a timestamp, (negative values are ok).


Converts a timestamp into a human-readable formatted date based on the supplied format.

Some common examples:

  • M is a short text version of a month, like Jul, while m is the numeric version like 07

  • Y is the 4 digit representation like 2023, etc. while y is the 2 digit version 23

  • To achieve something like May 4th, 2023, you would use: F jS, Y

  • Other tools might use something like YYYY-MM-DD, but in Xano, you would use Y-m-d


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.

Parse format for May 4th, 2020
F jS, Y
Parse format for 30/03/2024 14:30:00
d/m/Y H:i:s
Parse format for 11-27-22 5:15PM
m-d-y g:iA
Parse format for 6/1/22 07:30:00 am
n/j/y h:i:s a


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.

to_ time since epoch

to_ms / to_seconds / to_mins / to_hours / to_days

Converts a regular expression into number of ms / secs / mins / hours / days since the UNIX epoch.

For example, a value of 'yesterday', 'three days ago' or even a date such as 'January 1, 2000' are all valid inputs for these filters and can help for quick timestamp conversions.

Last updated