SQL SERVER 中如何将YYYY-MM-DD转化为YYYYMMDD

Question

如需将‘2007-01-01’转化成‘20070101’,怎么写啊

Answer 1

DEclare @dt datetime
set @dt='2007-01-01'
select convert(varchar(8),@dt,112)--------
20070101(1 行受影响)

Answer 2

如果是日期型就用:
select convert(char(8),getdate(),112)如果是字符串就用:
select replace('2007-01-01','-','')

Answer 3

如果 ‘2007-01-01’ 是字符型DEclare @dt varchar(10)
set @dt='2007-01-01'
select replace(@dt,'-','')----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20070101(1 行受影响)

Answer 4

declare @t datetime
set @t='2008-01-12'
select convert(varchar(8),@t,112)