get today's date at midnight sql code example Example: sql today at midnight SELECT DATEADD(d, 0, DATEDIFF(d, 0, GETDATE()))