Posted by Ross Presser on 07/20/05 20:41

On Wed, 20 Jul 2005 16:56:42 GMT, Ray via SQLMonster.com wrote:

> 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,

declare @d1 smalldatetime
declare @d2 smalldatetime
declare @d3 smalldatetime

-- @d1 is the input date
set @d1 = CURRENT_TIMESTAMP
-- truncate hours, min, etc.
set @d1 = convert(smalldatetime, floor(convert(float, @d1)))

-- @d2 - last day of previous month

set @d2 = dateadd(day, - datepart(day, @d1), @d1)

-- @d3 - first day of previous month

set @d3 = dateadd(day, - datepart(day, @d2) + 1, @d2)

[Back to original message]