Timezone Offset

[mbartens]

Does this change the timestamp on records being INSERTED into the database?

[mazhar]

In database we store datetime in universal time without timezone offsets. Timezone information is stored as store setting. When you insert a product it will convert local date time to universal time and similarly when you load it will convert back to local time using time zone information.

[mbartens]

Ok, thank you. Apparently the time on the server is off.. when you insert a row do you get the time from sql or from the webserver?

[mazhar]

From web server.

[compunerdy]

I had a issue with this on reports.. I was trying to compare sales reports to what I downloaded into quickbooks. I could not get quickbooks and the AC reports to have all of the orders match as to which day the orders where placed. I could change my timezone settings to get dates to move around on the AC reports but I would always have at least 1 invoice up or down a day still. If quickbooks transfer is using the date in the DB is there some way to get the reports to use that same date?