mysql time and php time not the same

Question

When I use current_timestamp with MySQL, I get the correct time, but when I use

$mysqldate = date( 'Y-m-d H:i:s' );

I get the date with with an hour delay (eg, 4:42 PM is 5:42 PM). I understood that both function use the server's local time - can someone explain the difference?

Thanks.

You're certain your MySQL and PHP are on the same server, right? Some hosts put the MySQL on a different server. — ceejayoz
– ceejayoz, Commented Jun 9, 2009 at 12:38

Community · Accepted Answer · 2023-11-17 20:38:18Z

9

The global system time will be set via the /etc/localtime file, which will be either a symlink or a copy of a zone file from /usr/share/zoneinfo/ on most systems. Applications will use this as their default.

PHP can override this in a couple different ways:

date.timezone in php.ini
setting the TZ environment variable, e.g. putenv("TZ=US/Central");
date_default_timezone_set function (in PHP >= 5.1.0)

MySQL can override this by running the following query immediately after connecting:

SET time_zone = 'US/Central'

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Jun 9, 2009 at 14:04

Gabe Martin-Dempesy

8,0054 gold badges36 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Svetlozar Angelov · Accepted Answer · 2009-08-11 12:14:13Z

2

There are php locale settings, it takes it from php.ini, not from system time

edited Aug 11, 2009 at 12:14

answered Jun 9, 2009 at 12:23

Svetlozar Angelov

21.8k7 gold badges64 silver badges68 bronze badges

Comments

Piskvor left the building · Accepted Answer · 2009-06-09 12:17:30Z

1

Maybe your PHP server thinks it's in a different time zone or it uses different locale and daylight saving time rules.

answered Jun 9, 2009 at 12:17

Piskvor left the building

93.1k46 gold badges182 silver badges226 bronze badges

1 Comment

daniel Over a year ago

how do i get PHP to give me the default, server time that's listed on server's computer? PHP's date.timezone isn't set

Collectives™ on Stack Overflow

mysql time and php time not the same

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related