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)),
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)),
For Sql Server try this:
select dateadd(m, datediff(mm,0,getdate()) + 1, -.000009)