Truncating DateTime Columns

Hi All,



I'm trying to find an efficient and elegant way to truncate datetime columns to a whole date. Currently, when I perform this operation I use something like the following.



TSQL: Select Convert(datetime, Convert(varchar, column_name, 112)) from table_name

PSQL: Select trunc(column_name, 'DDD') from table_name


I've been using this TSQL code ever sense version 7, but I know there has to be a more efficient way other than converting to a varchar and back to a datetime. Over the years, I've tried looking for a more suitable method to perform the conversion in TSQL but this has always been the most practical and efficient method. The PSQL select statement is fast and graceful.



Thanks