Frequently Used DB2 Functions and Expressions

Get the number of days since 0001-01-01

SELECT DAYS('2016-12-25')

Convert date string to datetime type

SELECT date(to_date(string_date_column,'YYYY-MM-DD'))

Calculate difference in number of days between two dates

SELECT DAYS('2016-01-01') - DAYS('2015-01-01')

Get day of the month, month, and year

SELECT DAY('2016-12-25'), MONTH('2016-12-25'), YEAR('2016-12-25')

From DB2 v10, dates can be formatted with a desired format string

SELECT VARCHAR_FORMAT(date-column, 'YYYY-MM-DD HH:MI:SS')