|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-08-21 16:21 UTC] tony2001@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 08 08:00:01 2025 UTC |
Description: ------------ The date.timezone option defined in php.ini has no effect on PDO/Sqlite. date.timezone = Europe/Zurich Reproduce code: --------------- <? echo "<pre>"; echo ' PHP : ' . date("Y-m-j G:i:s"); date("D M j G:i:s T Y"); echo "<BR>"; echo ' UNIX : '; passthru("date '+%Y-%m-%d %H:%M:%S'"); echo "<BR>"; echo 'PDO/Sqlite : '; $db = new PDO("sqlite::memory:"); $query="select datetime('now')"; $row = $db->query($query); $result=$row->fetch(PDO::FETCH_NUM); echo $result[0]; ?> Expected result: ---------------- PHP : 2006-08-21 17:49:24 UNIX : 2006-08-21 17:49:24 PDO/Sqlite : 2006-08-21 17:49:24 Actual result: -------------- PHP : 2006-08-21 17:49:24 UNIX : 2006-08-21 17:49:24 PDO/Sqlite : 2006-08-21 15:49:24