AbleCommerce Shopping Cart Software

My server is set to EST, the timezone offset is set to EST in the global settings, yet when a order gets written to the orders table the OrderDate is 4 hours into the future. I tried changing the offset but it is always off by 4 hours. UTC I am guessing. Is there another place to check to get the orderdate timestamp to align to the server time? Or is subtracting 1/6 of day my workaround. Thanks

You should be set to Eastern DAYLIGHT Time, not Eastern STANDARD Time.

Set it to EDT.

Yes, this is done, with the same results being posted in the orders table. 4 hours ahead. Any other options?

Then the server itself has the wrong time or time zone set. Try CDT instead of EDT.

I think the date in the database is always the server time in UTC. The AC offset you mention is used when you access the order date via the API, display the order date on site, or include it in an email.

If you are using the date directly from the database, then you will need to convert it back to local server time yourself.

If you want the clock on the server to match the date recorded in the database, then you will need to configure the server to use GMT.

Thanks, that makes sense.