请问2004-12-20 21:15:33 如何转成 20041220211533 反过来又怎样呢?

Question

2004-12-20 21:15:33  转成 20041220211533        :
select replace(replace(replace('2004-12-20 21:15:33','-',''),' ',''),':','')

Answer 1

declare @sql varchar(20)
set @sql='2004-12-20 21:15:33  '
select left(replace(replace(@sql,'-',''),':',''),8)+right(replace(replace(@sql,'-',''),':',''),5)

Answer 2

select stuff(stuff(stuff(stuff(stuff('20041220211533',5,0,'-'),8,0,'-'),11,0,' '),14,0,':'),17,0,':')

Answer 3

2004-12-20 21:15:33  -> 20041220211533        
select replace(replace(replace('2004-12-20 21:15:33','-',''),' ',''),':','')2004-12-20 21:15:33  <- 20041220211533  
select stuff(stuff(stuff(stuff(stuff('20041220211533',5,0,'-'),8,0,'-'),11,0,' '),14,0,':'),17,0,':')