Date and Time Functions

Macro Name Returns Description
CURRENT_DATE One column for each input column Returns the current date in format
CURRENT_DAY One column for each input column Returns the current day of the month as a number in the range 1 - 31
CURRENT_MONTH One column for each input column Returns the current month of the year as a number in the range 1 - 12
CURRENT_WEEKDAY One column for each input column Returns the current weekday of the month as a number in the range 0 - 6
CURRENT_YEAR One column for each input column Returns the current year as a number
DATE One column for each input column Converts a date string into a Julian date
DATE_FORMAT One column for each input column Transforms date formats