Hi, I have a column where time is in MM:SSSS format.
I need this is total Seconds, how can i convert it into total seconds.
Try with this:
select CAST((INTERVAL '12:23' Minute to second) AS INTERVAL second(4))
Format MM:SSSS is not a valid format for time, MM:SS either.
It should be 'mi:ss'.