Hey,
I need to implement a date/timestamp arithmetic for an analytics platform. Most important use cases:
• Convert date/timestamp to string based on format pattern, e.g. YYYY-MM-DD
• Convert string, e.g. 2021-01-01 to date/timestamp
• Truncate date to year, quarter(e.g. 2010-04), month, week(ISO, both starting from Monday and Sunday), day, hour, minute, second
• Shift date by X days/weeks/years/...
• Handle timestamps with timezones. Convert to user requested timezone
Can you point me to relevant DOC or examples?
I found the reference of all functions
here, but there are listed functions of all types, so it's hard to find what I need.