select rcvtime=case when rctime is not null then stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T') end from tb
select rcvtime=case when rcvtime is not null then stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T') else rctime end from tb
lsqkeke(可可),我需要取得所有字段的值,可以实现吗?
select id, name, rcvtime=case when rcvtime is not null then stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T') else rctime end from tb
To: lsqkeke(可可), 字段很多,列举太麻烦.为什么不能用上*呢? 比如: select * rcvtime=case when rcvtime is not null then stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T') else rctime end from tb
可以! select *, rcvtime=case when rcvtime is not null then stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T') else rctime end from tb
select stuff(replace(replace(convert(varchar(20),cast('1996-5-3' as datetime),120),'-',''),':',''),9,1,'T')
--结果是 2006-02-08 11:25:48.123select REPLACE(REPLACE(REPLACE(convert(varchar(19),getdate(),120),'-',''),' ','T'),':','')
--结果是 20060208T112548
另外,还要判断rcvtime是否为NULL,若为NULL就不转化了.
麻烦大家了.
stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T') end
from tb
stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T')
else rctime end
from tb
name,
rcvtime=case when rcvtime is not null then
stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T')
else rctime end
from tb
字段很多,列举太麻烦.为什么不能用上*呢?
比如:
select *
rcvtime=case when rcvtime is not null then
stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T')
else rctime end
from tb
select *,
rcvtime=case when rcvtime is not null then
stuff(replace(replace(convert(varchar(20),rcvtime,120),'-',''),':',''),9,1,'T')
else rctime end
from tb