Dateadd function & CURRENT_TIMESTAMP

Question

How do I return the date of 10/01/2009(first day of previous month) when using DATEADD function and CURRENT_TIMESTAMP.

Answer 1

0

SELECT [Now] = CURRENT_TIMESTAMP,            
    [1st of this month] = DATEADD(Month, DATEDIFF(Month, 0, CURRENT_TIMESTAMP), 0),            
    [1st of last month] = DATEADD(Month, DATEDIFF(Month, 0, CURRENT_TIMESTAMP)-1, 0)

answered Nov 05 '09 at 12:27 AM

Kristen ♦
2.2k ● 6 ● 7 ● 10

(comments are locked)

Dateadd function & CURRENT_TIMESTAMP

Follow this question

Related Questions