ScottAtRedHawk of Red Hawk
2/26/2018 - 9:12 PM

SQL Date Midnight

GETDATE() always includes current time, but often you need the current date starting from midnight.

TodayMidnight.sql
content_copyfile_download
DECLARE @TODAYMIDNIGHT AS DATE
SET @TODAYMIDNIGHT = DATEADD(DAY, 0, DATEDIFF(DAY, 0, GETDATE()))
SELECT @TODAYMIDNIGHT