Bug #71758 convert_tz does not work for datetime values > 2038-01-19 03:14:07
Submitted: 18 Feb 2014 13:09 Modified: 19 Feb 2014 14:56
Reporter: Christian Maus Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S2 (Serious)
Version:5.1.69 OS:Any
Assigned to: CPU Architecture:Any

[18 Feb 2014 13:09] Christian Maus 
Description:
The function does not work for values greater than 2038-01-19 03:14:07 (the biggest value that may be stored in a timestamp).

How to repeat:
select convert_tz(str_to_date('2038-01-19 03:14:08', '%Y-%m-%d %H:%i:%s'), 'GMT', 'Europe/Berlin');

returns

'2038-01-19 03:14:08'

instead of the expected

'2038-01-19 04:14:08'
[18 Feb 2014 14:00] Christian Maus 
Can be reproduced with current version 5.6.16 as well
[18 Feb 2014 14:11] MySQL Verification Team 
Please check duplicate http://bugs.mysql.com/bug.php?id=71754. Thanks.
[19 Feb 2014 8:54] Peter Laursen 
As the reporter of bug71754 I don't think that this is a full duplicate.  But is is another example that functions operating on datetime values depend on 32 bit unix timestamps internally - also on 64 bit systems (like also http://bugs.mysql.com/bug.php?id=12654 and http://bugs.mysql.com/bug.php?id=24625 also are).