Bug #24625 from_unixtime() for 64bits system
Submitted: 27 Nov 2006 16:23 Modified: 2 Apr 2007 11:46
Reporter: Roberto Spadim (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:all OS:Any (all)
Assigned to: CPU Architecture:Any
Tags: from_unixtime

[27 Nov 2006 16:23] Roberto Spadim 
Description:
should select from_unixtime(power(2,60)) work for 64-bits system?
bug 9191 change mysql to work with 2^31-1, but in 64 system this could be 2^63-1 right?

How to repeat:
should select from_unixtime(power(2,60))

Suggested fix:
maybe OS specific features?
[28 Nov 2006 9:34] Valeriy Kravchuk 
Thank you for a problem report. According to http://en.wikipedia.org/wiki/Unix_time, it looks like a reasonable feature request for me (to support 64-bit on OSes whete time_t is 64 bit). Surely, it can be OS-dependent.
[28 Nov 2006 15:28] Roberto Spadim 
maybe an OS independent implementation could help? just for from and to unix_timestamp functions
we could use only 64 int and get fractions of second from OS
what are you thinking?
[2 Apr 2007 11:46] Valeriy Kravchuk 
This is a duplicate of bug #12654. Work in progress already.