Some Useful T-SQL DateTime Functions ~ Don't Call Us - We'll Call You

Thursday, April 30, 2009

Some Useful T-SQL DateTime Functions

Example:

----First Day of Last Month
SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))

----Last Day of Last Month
SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)))

Lagt inn av kl.
Etiketter:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)