This script will get you the current date minus the time. It will display all zeros instead.
Date without the time
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()))