SQL SERVER - Few Useful DateTime Functions to Find Specific Dates
Posted by: Journey to SQL Authority with Pinal Dave,
on 29 Aug 2008 |
View original | Bookmarked: 0 time(s)
Recently I have recieved email from Vivek Jamwal, which contains many useful SQL Server Date functions. —-TodaySELECT GETDATE() ‘Today’—-YesterdaySELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’—-FirstDayofCurrentWeekSELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘FirstDayofCurrentWeek’—-LastDayofCurrentWeekSELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘LastDayofCurrentWeek’—-FirstDayofLastWeekSELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) ‘FirstDayofLastWeek’—-LastDayofLastWeekSELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6)...