求时间差（秒为单位）

[st_snake_china]

153215和153325的时间差多少秒怎么算阿？都是int格式

[boydgmx]

SELECT 3600*24*ABS(To_Date('153215', 'HH24MISS') -To_Date('153325', 'HH24MISS')) FROM DUAL;

[st_snake_china]

我这边数据库里早上的时间00:12:13秒是这样表示的1213,前面如何补0啊

[goldarcher2005]

SELECT 3600*24*ABS(To_Date(to_char('3215','000000'), 'HH24MISS') -To_Date(to_char('3325','000000'), 'HH24MISS')) FROM DUAL;

[citywanderer2005]

Select Round(To_Number(To_Date('153215', 'HH24MISS') -To_Date('153325', 'HH24MISS')) * 24 * 60 *60, 1 )
From Dual