Skip to content

Instantly share code, notes, and snippets.

@kristinaconley
Created August 9, 2013 20:39
Show Gist options
  • Save kristinaconley/6197001 to your computer and use it in GitHub Desktop.
Save kristinaconley/6197001 to your computer and use it in GitHub Desktop.
SELECT
CAST(CONVERT(VARCHAR(10),GETDATE(),110) AS DATETIME) AS 'Today Start'
,DATEADD(s,-1,CONVERT(VARCHAR(10),GETDATE()+1,101)) AS 'Today End'
,CAST(DATEDIFF(dd,0,GETDATE()-1) AS DATETIME) AS 'Yesterday Start'
,DATEADD(s,-1,DATEADD(dd, DATEDIFF(dd,0,GETDATE()),0)) AS 'Yesterday End'
,CONVERT(VARCHAR(10), (DateAdd(DD, - 1 * (datepart(dw, GETDATE())), GETDATE() + 1)), 110) AS 'Week to Date Start'
,DATEADD(s,-1,DATEADD(dd, DATEDIFF(dd,0,GETDATE()),0)) AS 'Week to Date End'
,CONVERT(VARCHAR(10), (DateAdd(DD, - 1 * (6 + datepart(dw, GETDATE())), GETDATE())), 120) AS 'Prior Week Start'
,CONVERT(VARCHAR(10), (DateAdd(DD, -1 * (datepart(dw, GETDATE())), GETDATE())), 120) + ' 23:59:59' AS 'Prior Week End'
,CAST(DATEDIFF(dd,0,GETDATE()-7) AS DATETIME) AS 'Last 7 Days Start'
,DATEADD(s,-1,DATEADD(dd, DATEDIFF(dd,0,GETDATE()),0)) AS 'Last 7 Days End'
,DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0) AS 'MTD Start'
,convert(DATETIME, convert(VARCHAR(10), getdate(), 101)) AS 'MTD End'
,DATEADD(month, DATEDIFF(month, 0, GETDATE())-1, 0) AS 'Previous Month Start'
,DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1) AS 'Previous Month End'
,convert(datetime,convert(varchar(10), GETDATE(), 101)) - 30 AS 'Rolling 30 Days Start'
,DATEADD(s,-1,DATEADD(dd, DATEDIFF(dd,0,GETDATE()),0)) AS 'Rolling 30 Days End'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment