一个带年月日时分秒的时间字段,怎样只修改其年月日,时分秒保留原值? select xfsj = '2008-04-14 ' + convert(varchar,xfsj,114) from tabupdate ta set xfsj = '2008-04-14 ' + convert(varchar,xfsj,114) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select dateadd(d, datediff(d, '2015-10-02 20:23:00.000', '2008-4-14') ,'2015-10-02 20:23:00.000')/*-----------------------2008-04-14 20:23:00.000(1 row(s) affected)*/ Select xfsj='2008-04-14'+right(xfsj,13) from tb update tbSet xfsj='2008-04-14'+right(convert(char(23),xfsj,114),13)xfsj为datetime类型 update table set xfsj = dateadd(d, datediff(d, xfsj , '2008-4-14') ,xfsj)这个方法,我个人比较喜欢。 update tbSet xfsj=cast('2008-04-14'+right(convert(char(23),xfsj,114),13) as datetime) update tb set xfsj = '2008-04-14 ' + convert(varchar(8),xfsj,114) update tb set xfsj = '2008-04-14 ' + convert(varchar(8),xfsj,114)where convert(char(10),xfsj,120) <> '2008-04-14' UPDATE TbTemp SET xfsj = DATEADD(DAY,DATEDIFF(DAY,xfsj,'2008-4-14'),xfsj) declare @date varchar(20)set @date ='2008-04-16 'select @date + convert(varchar,CreateTime,114) datetimefromdbresult.dbo.TB_PASSSUPERTRANdatetime -------------------------------------------------- 2008-04-16 20:23:51:4172008-04-16 22:54:15:7672008-04-16 00:08:51:3172008-04-16 14:33:41:8972008-04-16 14:35:01:6002008-04-16 14:35:01:600 关系演算 诚心请教恢复数据库中RECOVERY选项用途 跪地:数据恢复时出现这样的提示,并且恢复不了,不知如何是好. 请指教数据库开发用什么语言较好? 關聯查找問題,求高手。。 BOM配方问题(如何跟据生产数得到所有原料数) 数据库每星期三出现有些SQL语句能正常查询,有些SQL语句查询很耗时 特定条件的数据求和 插入和删除的触发器怎么写 数据仓库,数据收集问题。DTS (数据库管理员请进) 函数返回NULL 数据库导入生成重复的表,请求帮助!
-----------------------
2008-04-14 20:23:00.000(1 row(s) affected)*/
Set xfsj='2008-04-14'+right(convert(char(23),xfsj,114),13)xfsj为datetime类型
update table set xfsj = dateadd(d, datediff(d, xfsj , '2008-4-14') ,xfsj)这个方法,我个人比较喜欢。
Set xfsj=cast('2008-04-14'+right(convert(char(23),xfsj,114),13) as datetime)
update tb set xfsj = '2008-04-14 ' + convert(varchar(8),xfsj,114)
where convert(char(10),xfsj,120) <> '2008-04-14'
UPDATE TbTemp SET xfsj = DATEADD(DAY,DATEDIFF(DAY,xfsj,'2008-4-14'),xfsj)
set @date ='2008-04-16 '
select @date + convert(varchar,CreateTime,114) datetime
from
dbresult.dbo.TB_PASSSUPERTRANdatetime
--------------------------------------------------
2008-04-16 20:23:51:417
2008-04-16 22:54:15:767
2008-04-16 00:08:51:317
2008-04-16 14:33:41:897
2008-04-16 14:35:01:600
2008-04-16 14:35:01:600