Hi all,
The statement
select dateadd(month, -1 , convert(datetime, '30-SEP-1996'
return Aug-30-1996.
but I want to get the last day of the month. (ie AUG-31-1996)
for example
select dateadd(month, -1 , convert(datetime, '30-SEP-1996'
I want MAY-31-1996 to return NOT MAY-30-1997.
Thanks in advance for your help
Tung Nguyen