Incorrect Date Time Stamp on Orders

I'm completely confused on this. Orders are showing a datetimestamp value that is 2 hours later than the actual time.

The server time is set to PST. The server lives in Texas and is CST (2 hours later). Everything on our server is showing the correct PST timestamps (logs, the time setting, the backups, etc.)

When I'm logged into Zen Cart Admin I see the correct PST time at the top of the screen. For example right now it says: Thu, 02 Sep 2010 10:52:13 -0700GMT and that is the correct west coast time.

The order timestamp is 2 hours later.

What's weird is the order confirmation e-mail that is generated by zen cart has the correct PST timestamp at the very bottom. For example the last order displays: Date and Time: Thu Sep 2 2010 10:40:05 PDT on the last line of the e-mail but the order itself in the database is: Sep 02, 2010 12:40:05 PM

We just moved to this dedicated server. I did not have this problem on our previous dedicated server (which is with the same host in Texas). The problem exists on both a 1.3.8 database on this server and our recently upgraded 1.3.9e database.

I'm still assuming it's something on the server side but I'm at a loss as to what setting it could possibly be. Are there any additional ways to query what zen cart is picking up and using for the timestamp?

Thank you!
Kathy

Your server administrator needs to set the time inside MySQL to match the time used on the rest of the server.

Thank you Dr. Byte! Of course you were correct. It was a small thing but was bugging the heck out of me.

For others reading this thread: in phpMyAdmin I looked under Variables. Time Zone was set to SYSTEM which was correct. System Time Zone was set to CST. After the server was re-booted the System Time Zone was re-set to PDT. The server hadn't been re-booted since the time zone was changed.