'How to convert an entire column of time into seconds (under 24 hours) in SQL [duplicate]

enter image description here

Hi all, I'm new to SQL and don't know anything about this DB. I need help in solving the following problem.

I want to convert the TimeC column into seconds and make a new column beside it. For example, in the very first row which has the value 00:08:22, I would like to know how many seconds have gone passed since 00:00:00

mysqlsql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions