Previous month First and Last Day

[PatelRam]

Friends...!!!

How do I find Previous month's first and last day from current date.

Thanks,

Ram

 

[blom0344]

Last day of last month:

SELECT CURRENT DATE - (DAY(CURRENT DATE) DAYS) from SYSIBM.SYSDUMMY1

Ties Blom
Information analyst

 

[blom0344]

First day of last month:

SELECT (CURRENT DATE - (DAY(CURRENT DATE) DAYS)) - 1 MONTH + 1 DAY from SYSIBM.SYSDUMMY1


Ties Blom
Information analyst

 

[PatelRam]

Thanks Ties Blom