Hey, I need to implement a date/timestamp arithmet...
# general
j
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.