Friday, April 22, 2011

Convert SQL TIME field to plain seconds

Here's something I do occasionally and always have to go search the interwebs for.
So let me write it somewhere I (and hopefully others) can find it easily.

select TIME_TO_SEC(FIELD_NAME) as MY_ALIAS_FIELD_NAME from TABLE...;

No comments: