| 04:30.17 | influx | in mysql, is there a function that will convert something from type time to decimal? |
| 04:31.03 | influx | Say I want to know what the decimal equivalent of 03:23:00 is, how would I go about that in a concise manner? |
| 05:32.32 | eggyknap | What do you want the decimal number to represent, exactly? |
| 05:32.39 | eggyknap | A number of seconds, for instance? |
| 05:35.00 | eggyknap | Looks like 5.1, at least, has a time_to_sec() function, which takes a time argument and turns it into a number of seconds. http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_time-to-sec |
| 14:43.12 | *** join/#udbug SunSparc (~sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 14:43.12 | *** mode/#udbug [+o SunSparc] by ChanServ |
| 15:01.23 | *** join/#udbug fungus (~olsonl@bromine.sosstaffing.com) |
| 15:01.23 | *** mode/#udbug [+o fungus] by ChanServ |
| 15:24.29 | influx | I would like to represent the number of hoursin decimal format. |
| 15:25.13 | influx | I was hoping to find a function that might do the conversion automatically, but I'll make do with time_to_sec() and perform the appropriate arithmetic. |
| 22:41.23 | *** join/#udbug fungus (~olsonl@bromine.sosstaffing.com) |
| 22:41.24 | *** mode/#udbug [+o fungus] by zelazny.freenode.net |