SQL中DateTime的更新时间部分
问题描述：
我想在SQL中更新我的datetime字段的时间部分.我有一个考勤表，用户可以根据他/她选择的考勤日期来更新时间.我该怎么办?
I want to update the time part of my datetime field in SQL. I have an attendance table wherein the User can update the time depending on which attendance date he/she picks. How can I do this?
答
在这里..myDate是表中的字段名称.我使用变量来保存时间值.如果需要任何说明，请告诉我.
Here you go..myDate is the field name in the table. I used variables to save time values. Please let me know if you need any clarification.
declare @TestTime datetime
declare @hour int=10
declare @min int=10
declare @sec int=12
select @TestTime = cast(convert(varchar(100),myDate,101)+' 00:00:00' as datetime) from TestTable
select dateadd(ss,@sec,dateadd(m,@min,dateadd(hh,@hour,@TestTime)))