Bug #26831 Time data type
Submitted: 4 Mar 2007 10:31 Modified: 4 Mar 2007 14:02
Reporter: Jagdeep Singh Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version:MySql 4.0 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[4 Mar 2007 10:31] Jagdeep Singh 
Description:
Sir
I want to store time of the order of 3000 hours. But MySql is only supporting arount 831 hours or 30days. Please suggest me how to go about it.
Is it a limitation of the language that you cant store the time more than 831 hours. Plz help sjagdeep@rediffmail.com

How to repeat:
I want to store time of the order of 3000 hours. But MySql is only supporting arount 831 hours or 30days. Please suggest me how to go about it.
Is it a limitation of the language that you cant store the time more than 831 hours. Plz help sjagdeep@rediffmail.com

Suggested fix:
I want to store time of the order of 3000 hours. But MySql is only supporting arount 831 hours or 30days. Please suggest me how to go about it.
Is it a limitation of the language that you cant store the time more than 831 hours. Plz help sjagdeep@rediffmail.com
[4 Mar 2007 14:02] Valeriy Kravchuk 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Please, read the manual (http://dev.mysql.com/doc/refman/4.1/en/time.html) about TIME type limitations. You may use other types (TIMESTAMP or just INT to store number of seconds/fractions of seconds elapsed) if these documented limitations make TIME type inappropriate in your case.

Thank you for your interest in MySQL.