Why is the date time different for PHP and MYSQL?

Asked Sep 23 '16 at 15:45

Active Sep 23 '16 at 15:56

Viewed 32 times

When I insert an entry into MYSQL the 'datetime' in my MYSQL entry is different from that registered with PHP. How can I make them register the same date and time? I am in the UK and I use the Godaddy server.

I have used the following to set the default time:

 date_default_timezone_set("Europe/London");

 // TO GET THE PRESENT DATE TIME
 $dateTimeNow = date("Y-m-d H:i:s");

For example I made an entry to to my database and I had the following differences in time:

 DateTime now (PHP): 2016-09-23 16:40:54
 DateTime of post (from MYSQL): 2016-09-23 08:06:52

 // FOR DATETIME INSERTION INTO MYSQL I USE
 now()

edited Sep 23 '16 at 15:56

asked Sep 23 '16 at 15:45

dave

1

Different you say? – AbraCadaver Sep 23 '16 at 15:47
Can you show us the differences that you are getting please – RiggsFolly Sep 23 '16 at 15:48
Where is the server running your MYSQ Server situated timezone wise – RiggsFolly Sep 23 '16 at 15:53
Yea, show us the code that stores this date to your table – RiggsFolly Sep 23 '16 at 15:54
please see above edit. I use 'now()' in sql to register the DATETIME – dave Sep 23 '16 at 15:54
`INSERT (to_date) values (NOW())` will use the servers timezone. Your `date_default_timezone_set("Europe/London");` is having no effect on this query at all – RiggsFolly Sep 23 '16 at 15:55
I am in the UK, and I use the Godaddy server. – dave Sep 23 '16 at 15:55
2

Then I guess the server is somewhere like USA West Coast – RiggsFolly Sep 23 '16 at 15:56
You need to set the timezone of mysql after connecting to it from php. Check this question http://stackoverflow.com/q/930900/80836 – Andreas Sep 23 '16 at 17:05

Why is the date time different for PHP and MYSQL?

0 Answers0