#49857 [NEW]: DST in Brazil will only begin in October 18th, not in 11th !!!

From: heitor dot siller at gmail dot com Operating system: RHEL 5 PHP version: 5.2.11 PHP Bug Type: Date/time related Bug description: DST in Brazil will only begin in October 18th, not in 11th !!! Description: ------------ DST in Brazil will only begin in October 18th, but PHP considered it has already started on October 11th. This is causing very significant problems in Brasilian web systems! DST in Brazil are weird, I mean, its rules changes every year. This year president Lula imposed it will begin every third October's sundays and will ends in the third February's sundays. Although now there is a general rule, there is still problems. For example: some Brazilian states just don't accept DST and they often win processes in justice to not follow DST. Other potential problem is there is 4 different time zones in Brazilian's huge territory (that is even bigger than continental USA), and "normally" only one has DST, who is "Brazil/East". To be honest, I can't see a simple solution for this bug, but what I'm sure is that a lot of people in Brazil will face a buggy week between October 11th and 18th! Reproduce code: --------------- Try to run <? $x = date("Y-m-d H:i:s"); exit($x); ?> in PHP an then compare to "SELECT localtime" in MySQL Expected result: ---------------- PHP result will show a date 1 hour ahead of MySQL's Actual result: -------------- PHP: 2009-10-13 01:27:37 MYSQL 2009-10-13 00:27:37 -- Edit bug report at http://bugs.php.net/?id=49857&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=49857&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=49857&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=49857&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=49857&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=49857&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=49857&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=49857&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=49857&r=needscript Try newer version: http://bugs.php.net/fix.php?id=49857&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=49857&r=support Expected behavior: http://bugs.php.net/fix.php?id=49857&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=49857&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=49857&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=49857&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49857&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=49857&r=dst IIS Stability: http://bugs.php.net/fix.php?id=49857&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=49857&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=49857&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=49857&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=49857&r=mysqlcfg