This script will get you the current date minus the time. It will display all zeros instead.
Current date without the timestamp
Select convert(datetime,convert(varchar(12),getdate()))
This script will get you the current date minus the time. It will display all zeros instead.
Select convert(datetime,convert(varchar(12),getdate()))