Package dev.frostlake.functions.scalar.datetime
package dev.frostlake.functions.scalar.datetime
-
ClassesClassDescriptionADD_MONTHS(input, n) — shifts a date or timestamp by
nmonths, preserving end-of-month: an input on the last day of its month lands on the last day of the target month.DAYOFWEEKISO(t) — ISO day of week, 1 (Monday) to 7 (Sunday).GETDATE() - the statement's instant in the session's zone, as TIMESTAMP_LTZ.NOW() / LOCALTIMESTAMP() — aliases of CURRENT_TIMESTAMP.SYSDATE() — the statement's instant in UTC, as TIMESTAMP_NTZ.SYSTIMESTAMP() - the statement's instant in the session's zone, as TIMESTAMP_LTZ.TIMEADD(unit, amount, datetime) — alias of DATEADD.TIMEDIFF(unit, start, end) — alias of DATEDIFF.TIME_SLICE(t, n, unit [, 'START'|'END']) — the start (default) or end of the n-unit bucket containing t.WEEKISO(t) — ISO-8601 week number.YEAROFWEEK(t) — the year the week belongs to (engine week = ISO week).YEAROFWEEKISO(t) — the ISO week-based year.