I need to convert time column into seconds.
for example:01:55:30 to 6930
Is there any function to convert this?
Your help is appreciated.
this will fail after 02:46:39 = 9999 seconds.
EXTRACT(HOUR FROM t) * 3600
+ EXTRACT(MINUTE FROM t) * 60
+ EXTRACT(SECOND FROM t)
It's easy to put this calculation in a SQL UDF.