DateTime Modification

Description

DateTime Constant Functions can be used to modify DATEs.

ADD_MILLIS, ADD_SECONDS, ADD_MINUTES, ADD_HOURS, ADD_DAYS, ADD_MONTHS and ADD_YEARS add a specified value of the corresponding time unit to a DATE.
ADD_WORKDAYS adds a specified number of workdays to a DATE using a specified TFACS style calendar table.
CONVERT_TIMEZONE converts a DATE input from specified timezone (or UTC timezone if not specified) to another specified timezone.