sql-server - 如何在 SQL Server 中将时间类型变量除以 2

Question

我有一个TIME类型的变量，我需要将该变量的时间除以2。

我的 SQL 代码:

DECLARE @TEMPO AS TIME = '01:31:00'

SELECT (@TEMPO / 2 ) AS RESULT

--the result should be: 00:45:30

但是 SQL Server 抛出错误:

Operand type clash: time is incompatible with int

欢迎任何帮助!

Answer 1

使用TIMEFROMPARTS(SQL Server 2012+):

DECLARE @TEMPO AS TIME = '01:31:00';
DECLARE @i INT = DATEDIFF(s, '00:00:00',@TEMPO)/2;

SELECT  TIMEFROMPARTS(@i/3600%60, @i/60%60 ,@i%60,0,0);
-- 00:45:30

<强> db<>fiddle demo