Posted by Ray via SQLMonster.com on 07/20/05 19:56

Hi there,

See if you can help me with the following:

I need to write an SQL code that will return me:

The 1st day & the Last day of the Previous Month in the following format
(smalldatetime):

yyyy-mm-dd hh:mi:ss (24h)

Regards,


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200507/1

• Next in forum: Re: Code for 1st day & the Last day of the Previous Month
• Prev in forum: Make changes to a production database!
• Thread view: Code for 1st day & the Last day of the Previous Month

[Reply to this message]