Stack Exchange
log in help

select getdate() , DATEPART(dw,getDate()) , dateAdd(dd,1-...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

select getdate()
     , DATEPART(dw,getDate())
     , dateAdd(dd,1-DATEPART(dw,getDate()),GETDATE())
     , DATEPART(d,getDate())
view current version

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results