Transact-SQL: Pack of useful Dates functions, calculations (day, week, month, year)
(475)Take a look on pack of very nice date functions, conversions, calculations.
Thanks to Pinal Dave(http://www.SQLAuthority.com) and Vivek Jamwal
—-Yesterday SELECT DATEADD(d,-1,GETDATE()) 'Yesterday' —-First Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) 'First Day of Current Week' —-Last Day of Current Week SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) 'Last Day of Current Week' --First Day of Last Week SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) 'First Day of Last Week'
All (much more!) statements you can see in original post on SQLAuthority: here
