Bug #347 sec_to_time function

• Submitted: 30 Apr 2003 4:09
• Modified: 30 Apr 2003 4:46
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.11.gamma
• OS: Windows (Windows 98)
• CPU Architecture: Any

[30 Apr 2003 4:09] [ name withheld ]

Description:
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

Thanks

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:

c:\mysql\bin>mysql
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)