从日期时间中删除分钟 - sql
问题描述:
DECLARE @MinutesToAdd int = 20;
DECLARE @StartTimeDate datetime = '2017-06-05 14:37:56.113';
DATEADD(minute,@MinutesToAdd,@StartTimeDate);
上面的代码将 20 分钟添加到 StartTimeDate.有没有好办法去掉那些20分钟不加的?试图找到解决方案,但没有找到.有什么想法吗?
Code above adds 20 minutes to StartTimeDate. Is there a good way to remove those 20 minutes not add? Tried to find a solution, but didn't catch one. Any ideas?
答
您没有任何特定的函数来减去任何日期部分
You don't have any specific function to subtract any dateparts
前面加负号
Select DATEADD(minute,-@MinutesToAdd,@StartTimeDate);
或乘以-1
Select DATEADD(minute,@MinutesToAdd * -1 ,@StartTimeDate);