How to remove the time portion of a datetime value (SQL Server)? * Cinema Guy 13:08 Add Comment Edit Question Here's what I use: SELECT CAST(FLOOR(CAST(getdate() as FLOAT)) as DATETIME) I'm thinking there may be a better/more ... Read More