mysql datetime shows differently on php page

Question

I am working on shopping cart, which stores DateTime in orders table when order is placed.

one of the row in order table shows date time 2015-07-24 02:34:45

When I display same on PHP page it displays 2015-07-24 01:43:33

It is happening with all entries in orders table. I am considering just one here, date displays correctly but time is not displaying properly

Default time zone is America/New_York

I am just selecting rows from order table and displaying on a PHP page.

How are you displaying the date time on your page? How is the date stored on your database? — Mark Baker
– Mark Baker, Commented Jul 29, 2015 at 7:15
what framework / function are you using for displaying and saving date? — Asad Nauman
– Asad Nauman, Commented Jul 29, 2015 at 7:16
MySql and PHP have separate configurations for timezones. So NOW() in MySql doesn't have to use the same timezone as set in PHP — ArtisticPhoenix
– ArtisticPhoenix, Commented Jul 29, 2015 at 7:16
Best to always save dates / times as UTC and adjust as needed when outputting. Makes life much easier and consistent. — RhapX
– RhapX, Commented Jul 29, 2015 at 7:22

Vincent · Accepted Answer · 2015-07-29 08:16:18Z

2

Setting GLOBAL value by command line will be reset if you restart your MySql. Instead set this in your my.cnf like

default-time-zone = "America/New_York"

Don't forget to restart your MySql after setting the option

answered Jul 29, 2015 at 8:16

Vincent

666 bronze badges

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

Comments

Javi · Accepted Answer · 2015-07-29 07:23:24Z

2

Mysql timezone != PHP timezone, you need set both separately. If your php.ini have America/New_York you need execute this mysql query:

SET GLOBAL time_zone = 'America/New_York';

answered Jul 29, 2015 at 7:23

Javi

5063 silver badges15 bronze badges

it will be apply to current database or all database ?, i have number of other databse too