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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.