This script will get you the current date minus the time. It will display all zeros instead.
DATETIME is stored as a number in SQL and less internal conversions are will be used then other methods. Microsoft generally uses this method.
Display current date minus the time
SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, GETDATE())))