Convert date and time I have a column with about 100 records in datetime (for example 2004-08-09 12:20:41:000) and I would like to convert all records or update same time just date only with format mm-dd-yyyy.

Thank you.
For SQl Server 2008 you can use convert function like below.

--For output format mm-dd-yyyy
declare @d datetime = getdate() 
select convert(varchar(10), @d, 110)

--For output format yyyy-mm-dd
declare @d datetime = getdate() 
select convert(varchar(10), @d, 120)


If you are using SQL Server 2012 and later, the new format function works fine too. Example below.

--For output format mm-dd-yyyy    
declare @d datetime = getdate()
select format(@d,'MM-dd-yyyy', 'en-US')

--For output format yyyy-mm-dd
declare @d datetime = getdate() 
select format(@d,'yyyy-MM-dd', 'en-US')