All Forums General
teradata006 8 posts Joined 03/12
26 Mar 2012
SQL for the current month begin date and end date

Hello all,

 

I am new to the terdadata database and looking for some help regarding sql for the current month begin date and current month end date

ulrich 816 posts Joined 09/09
26 Mar 2012

Select (current_date - extract(day from current_date))+1 ,

add_months(current_date,1) - extract(day from add_months(current_date,1)) 

Ulrich

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

whitestorm2k 8 posts Joined 09/04
26 Mar 2012

FYR...

select date
,cast(date/100*100+1 as date)
,add_months(cast(date/100*100+1 as date),1)-1;

You must sign in to leave a comment.