Date and Time Functions
Macro Name
Returns
Description
ADD_MONTHS
One column for each input column
Returns a date after adding the specified number of months
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 from 1-31
CURRENT_MONTH
One column for each input column
Returns the current month of the year as a number from 1-12
CURRENT_WEEKDAY
One column for each input column
Returns the current weekday of the month as a number from 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 2013. All Rights Reserved.