• here's just a different variation:

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