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

[breeze_air]

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

[JL99000]

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

[areswang]

二楼说的全。

[kk19840210]

DEclare @dt datetime
set @dt='2007-01-01'
select convert(varchar(8),@dt,112)

--------
20070101

(1 行受影响)

[gahade]

如果是日期型就用:
select convert(char(8),getdate(),112)

如果是字符串就用:
select replace('2007-01-01','-','')

[kk19840210]

如果 ‘2007-01-01’ 是字符型

DEclare @dt varchar(10)
set @dt='2007-01-01'
select replace(@dt,'-','')

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
20070101

(1 行受影响)