MS SQL Date Only Without Time May 18, 2023 by Tarik If you’re using SQL Server 2008 it has this built in now, see this in books online CAST(GETDATE() AS date)