Date Help 1

[strom99]

I have the following

select
cast(substr(date,1,8)||'01' as date format 'yyyy-mm-dd') as FirstDay,

cast(substr(add_months (cast (substr(date,1,8)||'15' as date format 'yyyy-mm-dd'), 1),1,8)||'01' as date format 'yyyy-mm-dd') - 1 as LastDay,

cast(substr(add_months(date,-1),1,8)||'01' as date format 'yyyy-mm-dd') FirstDayLM

Need one more to determine the last day of the last month, any ideas?

Thanks Much

 

[BillDHS]

Subtract one from the first day of current month

 

[strom99]

How do I accomplish that, I did not write the above so I am a little confused.

Thanks

 

[strom99]

Need to calculate the Last Day of the last month.
I have the following

select
cast(substr(date,1,8)||'01' as date format 'yyyy-mm-dd') as FirstDayCurrentMonth,

cast(substr(add_months (cast (substr(date,1,8)||'15' as date format 'yyyy-mm-dd'), 1),1,8)||'01' as date format 'yyyy-mm-dd') - 1 as LastDayCurrentMonth,

cast(substr(add_months(date,-1),1,8)||'01' as date format 'yyyy-mm-dd') FirstDayLastMth


Thanks

 

[alexfriedman]

check a syscalendar!!!
Subtract one from the first day of current month

 

[BillDHS]

Take the first attribute of the select statement you have and subtract 1.

(cast(substr(date,1,8)||'01' as date format 'yyyy-mm-dd')) -1 as Last Day of Last Month,

 

[dnoeth]

select date - extract(day from date);

Dieter