34,594
社区成员
发帖
与我相关
我的任务
分享
create table tt (date nvarchar(10),time nvarchar(10),date_time nvarchar(50))
insert into tt values('2004-02-23','14:21:50','')
select * from tt
/*
date time date_time
---------- ---------- --------------------------------------------------
2004-02-23 14:21:50
(所影响的行数为 1 行)
*/
update tt
set date_time=convert(char(10),cast(date as datetime),103)+' '+time
select * from tt
/*
date time date_time
---------- ---------- --------------------------------------------------
2004-02-23 14:21:50 23/02/2004 14:21:50
(所影响的行数为 1 行)
*/
declare @t datetime
declare @s1 varchar(20),@s2 varchar(20)
set @s1='2004-02-23'
set @s2='14:21:50'
set @t=@s1+' '+@s2
select @t
create table wuying8331
(
Date nvarchar(20),
Time nvarchar(20)
)
insert into wuying8331
select '2004-02-23','14:21:50'
select convert(varchar(20),cast(Date as datetime),103)+' '+Time as date_time from wuying8331
select convert(char(10),[date]+' '+ [time],101)+':'+[time]
from table