Posted by Aaron on 07/13/07 21:13

I was reading the article and was unable to get some of queries to
execute. Can anyone help get these to work:

How to get the last day of the previous month? And the last day of the
current month?

SELECT DATEADD(month, DATEDIFF(month, '20000101', CURRENT_TIMESTAMP),
'19991231')
SELECT DATEADD(month, DATEDIFF(month, '20000101', CURRENT_TIMESTAMP),
'20000131')

Thanks,
Aaron

• Next in forum: Re: Connect to sql server 2005 Standard thru internet
• Prev in forum: Re: Backup Structure Only
• Thread view: Re: Date Range for SQL 2005

[Reply to this message]