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/knowledge...