IT/MSSQL
DATETIME TO STRING
rossella
2010. 4. 29. 15:35
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),':','')
set @DT ='2010-03-09 16:22:27.980'
select replace(Convert(varchar(30),@DT,110),'-','') + replace(Convert(varchar(30),@DT,108),':','')