| Bug #10590 | Function 'TIME_FORMAT(time,format)' does not display correct result. | ||
|---|---|---|---|
| Submitted: | 12 May 2005 11:56 | Modified: | 23 Jun 2005 12:56 |
| Reporter: | Disha | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.5-beta pre-release | OS: | Windows (Windows Server 2003) |
| Assigned to: | Jim Winstead | CPU Architecture: | Any |
[12 May 2005 12:03]
MySQL Verification Team
Verified on Linux.
[27 May 2005 23:41]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/25368
[4 Jun 2005 0:48]
Jim Winstead
Pushed for 5.0.7.
[23 Jun 2005 12:56]
Jon Stephens
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at http://www.mysql.com/downloads/ Additional info: Documented bugfix in 5.0.7 changelog; marked as Closed In Release.
[3 Jan 2006 5:30]
Marcus VinÃcius de Lima
Hello, I've been lokking for a solution about time formats larger than 0to23. When I use the comand timediff(lasttime, firsttime) i get the real time value for example (100:00:00) but when i use the comand SUM() the format get error again. Someone can help me? Thanks.
Description: Function 'TIME_FORMAT(time,format)' does not display correct result. How to repeat: 1. delimiter // 2. create database test// 3. use test 4. set @@sql_mode='traditional'// 5. select time_format('100:00:00', '%H %k %h %I %l')// 6. Execution of step (5) displays the result as, +--------------------------------------------+ | time_format('100:00:00', '%H %k %h %I %l') | +--------------------------------------------+ | 100 100 100 100 100 | +--------------------------------------------+ Expected Result: The function 'TIME_FORMAT(time,format)' should return appropriate result. Actual Result : The execution displays the result as, +--------------------------------------------+ | time_format('100:00:00', '%H %k %h %I %l') | +--------------------------------------------+ | 100 100 100 100 100 | +--------------------------------------------+