34,587
社区成员
发帖
与我相关
我的任务
分享
--> 测试数据:[tb]
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([col] varchar(50))
insert [tb]
select '2008-8-8'
update tb set col=convert(varchar(10),cast(col as datetime),120)
select * from tb
/*
col
--------------------------------------------------
2008-08-08
(1 行受影响)
*/
alter table tb alter column fdate datetime
select convert(varchar(10),'2009-09-8',120) ---1
----------
2009-09-8
select convert(varchar(10),cast('2009-09-8' as datetime),120) --2
----------
2009-09-08
declare @sDate datetime
set @sDate ='2009-3-1'
select convert (nvarchar(10),@sDate,120)
update tb set
fdate=convert(varchar,cast(fdate as datetime),23)
UPDATE TB SET COL=CONVERT(VARCHAR(10),CONVERT(DATETIME,COL),120)
UPDATE TB SET TIME=CONVERT(VARCHAR(10),TIME,120)
update tablename set 时间列=convert(varchar(10),时间列,120)
UPDATE TB SET COL=CONVERT(VARCHAR(10),COL,120)
SELECT CONVERT(VARCHAR(10),COL,120)
update labrecord
set useddate=convert(varchar(10),cast(RTRIM(LTRIM(useddate)) as datetime),120)