可以通过datediff函数进行时间差: sql :select datediff(hh,'2012-12-11 8:00:00','2012-12-11 09:31:47') from dual ; 语法: DATEDIFF ( datepart , startdate , enddate ) datepart 缩写 year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms microsecond mcs nanosecond ns
冰依湄凌
2025-03-30 03:28:47
可以通过datediff函数进行时间差: sql :select datediff(hh,'2012-12-11 8:00:00','2012-12-11 09:31:47') from dual ; 语法: DATEDIFF ( datepart , startdate , enddate ) datepart 缩写 year yy, yyyy quarter qq, q month mm, m dayofyear dy, y day dd, d week wk, ww hour hh minute mi, n second ss, s millisecond ms microsecond mcs nanosecond ns