CONVER DATETIME TO STRING SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] IT/MSSQL 2010.06.21
DATETIME TO STRING Declare @DT datetime set @DT ='2010-03-09 16:22:27.980' select replace(Convert(varchar(30),@DT,110),'-','') + replace(Convert(varchar(30),@DT,108),':','') IT/MSSQL 2010.04.29