A Bad Dog Day
Showing posts with label
time
.
Show all posts
Showing posts with label
time
.
Show all posts
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...;
Older Posts
Home
Subscribe to:
Comments (Atom)