Useful DB2 BIF for handling date and time | yusy4code

I have explained about below Build-In Functions of DB2 for i

– NOW
– CURDATE
– CURTIME

– MONTHNAME
– DAYNAME
DAYNAME( ‘2019-05-28’ )

– DAYOFMONTH (or) DAY

– DAYOFWEEK (1 = SUNDAY)
– DAYOFWEEK_ISO (1 = MONDAY)

– DAYOFYEAR
– JULIAN_DAY

– WEEK

– LAST_DAY – LAST DAY OF A MONTH
– NEXT_DAY
NEXT_DAY(CURRENT_DATE, ‘TUESDAY’)
NEXT_DAY(‘2019-05-28’, ‘WED’)

– QUARTER

– ADD_MONTHS
ADD_MONTHS(‘2019-05-29’, 4)

– MONTHS_BETWEEN
MONTHS_BETWEEN(‘2019-05-28′,’2019-08-10’)

list of scalar functions of DB2
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzscale.htm