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