Bug #32045 sec_to_time returns wrong values

• Submitted: 2 Nov 2007 5:53
• Modified: 2 Nov 2007 8:11
• Reporter: Stefano Locati
• Status: Duplicate
• Category: MySQL Server: DML
• Severity: S2 (Serious)
• Version: 5.0.45-Debian_1ubuntu3-log
• OS: Linux (ubuntu 7.10)
• CPU Architecture: Any

[2 Nov 2007 5:53] Stefano Locati

Description:
SELECT sec_to_time(3564000)

returns 838:59:59 instead of 990 hours which is the correct value 3564000/3600=990

for the moment i can workaround doing the computation myself.

I tried on mysql 5.0.16 linux and there the function gave the correct result.

How to repeat:
SELECT sec_to_time(3564000)

returns 838:59:59 instead of 990 hours

[2 Nov 2007 8:11] Hartmut Holzgraefe

Duplicte of bug #29381