Bug #347 sec_to_time function
Submitted: 30 Apr 2003 4:09 Modified: 30 Apr 2003 4:46
Reporter: [ name withheld ] Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.11.gamma OS:Microsoft Windows (Windows 98)
Assigned to: CPU Architecture:Any

[30 Apr 2003 4:09] [ name withheld ]
Strange results with SEC_TO_TIME funcion

How to repeat:
SELECT SEC_TO_TIME(97200) i get 23:00.00 while on another server

Linux i get 27:00:00 which seems the correct result


Suggested fix:
Have no idea.. but it looks like the all timing area of the windows version needs a look at.
[30 Apr 2003 4:46] MySQL Verification Team
I tested on Win95/Win2k with the below result:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT SEC_TO_TIME(97200);
| SEC_TO_TIME(97200) |
| 27:00:00           |
1 row in set (0.11 sec)