TSQL – GETDATE() Timestamp to 00:00:00

Here is how you get the 00:00:00 timestamp for GETDATE() or any other date:

SELECT DATEADD(d, DATEDIFF(d, 0 , DATEADD(d, 1, GETDATE())),0)