sql:
declare @DateOld varchar
set @DateOld = convert(varchar,getdate(),120)
select @DateOld
输出:2select convert(varchar,getdate(),120)
输出:2010-02-03 15:50:37为什么同样的转换赋给变量再输出 结果不一样。还有:
declare @DateOld varchar
set @DateOld = '2000-01-12'
select substring(@DateOld,0,6)
select substring('2000-01-12',0,6)
declare @DateOld varchar
set @DateOld = convert(varchar,getdate(),120)
select @DateOld
输出:2select convert(varchar,getdate(),120)
输出:2010-02-03 15:50:37为什么同样的转换赋给变量再输出 结果不一样。还有:
declare @DateOld varchar
set @DateOld = '2000-01-12'
select substring(@DateOld,0,6)
select substring('2000-01-12',0,6)
set @DateOld = convert(varchar(10),getdate(),120)
select @DateOld
输出:2 select convert(varchar(30),getdate(),120)
输出:2010-02-03 15:50:37
sql:
declare @DateOld varchar(30)
set @DateOld = convert(varchar,getdate(),120)
select @DateOld
输出:
------------------------------
2010-02-03 16:05:01select convert(varchar,getdate(),120)
输出:2010-02-03 16:05:09
set @DateOld = convert(varchar,getdate(),120)
select @DateOld