Truncate datetime

select cast(getdate() as date)
Advertisements