Thread
:
Date function in DB2 V8.1 for Z/OS
View Single Post
#
4
(
permalink
)
05-07-2008, 11:15 AM
Tonkuma
Posts: n/a
Re: Date function in DB2 V8.1 for Z/OS
CURRENT DATE - (DAY(CURRENT DATE)-1) DAYS - 1 MONTH
or
CURRENT DATE - (DAYOFMONTH(CURRENT DATE)-1) DAYS - 1 MONTH
Tonkuma