Toad World® Forums

How to get last day of the month


#1

Hi Everyone, I am using Toad cross connection tool and I want to know ‘How to get last day of the month’. tried this

DateAdd (“m”,-1,DateAdd (“m”,0,DateDiff ( “m”, 0, DATE())+1)),


#2

For Sql Server try this:

select dateadd(m, datediff(mm,0,getdate()) + 1, -.000009)