Date and Time Functions
Macro Name
Returns
Description
ADD_MONTHS
One column for each input column
Adds the specified number of months and returns a date
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
Copyright IBM Corporation 2015. All Rights Reserved.