比如说样例数据时间是 需要得出18:15-14:20的时间差
写在sql里怎么写
sql里直接减法会报错
SELECT
(to_timestamp('18:15', 'MI:SS') - to_timestamp('14:20', 'MI:SS'))::interval AS time_diff;
oracle?SqlServer?mysql?
SELECT (TIME '12:00:00' - TIME '10:00:00') / INTERVAL '1 minute'
SELECT (TIME '18:15' - TIME '14:20') AS time_difference;