Current timestamp in PHP and MySQL

Question

I am using PHP to print the current timestamp using time() and I have a MySQL column which stores the date, which I am converting to a timestamp using strtotime(). However, when I print the converted values, I have a one hour difference between them. The real difference is in seconds. What's wrong?

What's your timezone setting in PHP, and what's the timezone setting in MySQL? There is your answer. — Wrikken
– Wrikken, Commented Aug 2, 2011 at 22:27
Bet the server you're running the commands on (or the mysql config) is an hour off. — Noah
– Noah, Commented Aug 2, 2011 at 22:27
@Wrikken: Could have earned you at least 10 points if you posted that as an answer. — GolezTrol
– GolezTrol, Commented Aug 2, 2011 at 22:28

sagi · Accepted Answer · 2011-08-02 22:31:29Z

3

Assuming they both run on the same physical server, it is probably a timezone mismatch.

You can check the timezone on your MySQL server by running the following query in the MySQL console:

SELECT @@global.time_zone;

And on your PHP page by running a script with:

echo date_default_timezone_get();

Once you figure out which one is wrong, you should be able to fix this by editing my.cnf or php.ini.

You can also change the default timezone on runtime using date_default_timezone_set().

answered Aug 2, 2011 at 22:31

sagi

5,7621 gold badge34 silver badges31 bronze badges

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

Comments

Steve Robbins · Accepted Answer · 2011-08-02 22:34:49Z

2

Set your timezone before inserting your times

date_default_timezone_set('America/Los_Angeles'); // Whatever your timezone is

mysql_query("INSERT
            INTO table
            (date)
            VALUES
            (" . time() . ")") or die(mysql_error());

answered Aug 2, 2011 at 22:34

Steve Robbins

13.8k12 gold badges81 silver badges129 bronze badges

Comments

ICL1901 · Accepted Answer · 2011-08-03 03:10:37Z

0

You may want to use the PHP strftime function, as it does take local timezones into account. You may be running into a daylight savings time issue.

answered Aug 3, 2011 at 3:10

ICL1901

7,77814 gold badges96 silver badges144 bronze badges

Comments

Pang · Accepted Answer · 2015-04-24 01:32:31Z

0

Use MySQL's UNIX_TIMESTAMP() function to get the current epoch time:

INSERT INTO mytable SET tstamp = UNIX_TIMESTAMP();

edited Apr 24, 2015 at 1:32

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Oct 19, 2012 at 4:54

Gaurang

1,95818 silver badges12 bronze badges

Collectives™ on Stack Overflow

Current timestamp in PHP and MySQL

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related