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).
add_secs_to_timestamp: Add seconds to a timestamp, (negative values are ok).
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.
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.