ChangeDateTpFirstOfNextMonth

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kristy de Don » ChangeDateTpFirstOfNextMonth

ChangeDateTpFirstOfNextMonth

Rate Topic

Display Mode

Topic Options

Author

Message

madyson3

Posted Thursday, August 07, 2008 9:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:25 PM
Points: 7, Visits: 123

Comments posted to this topic are about the item ChangeDateTpFirstOfNextMonth

Post #548368

wildh

Posted Thursday, August 14, 2008 1:33 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:08 AM
Points: 292, Visits: 657

If your want to remove the time portion of the result you could use this - select dateadd(month,datediff(month,-1,getdate()),0)

Post #552459

rgillings

Posted Thursday, August 14, 2008 5:12 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:13 PM
Points: 1,388, Visits: 235

Alternately, you can also use the DATEPART function instead of DATEDIFF:

DECLARE @Date DATETIME
SET @Date = GETDATE()
SELECT DATEADD(MONTH,1,DATEADD(DAY, (-1 * DATEPART(DAY,@Date)) + 1, @Date))

Post #552572

Tomm Carr

Posted Thursday, August 14, 2008 11:38 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, February 27, 2012 9:14 AM
Points: 501, Visits: 783

You can truncate the time part and simplify the calculation in one swell foop:

select DateAdd( m, DateDiff( m, 0, @NextMonth ) + 1, 0 );

Leave out the "+ 1" and you get the first day of this month.

Tomm Carr
--
Version Normal Form -- http://groups.google.com/group/vrdbms

Post #552948

« Prev Topic | Next Topic »

Permissions