Time Zone difference Bug in database

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 anos atrás
when any user registers on the website OR admin manually creates the user. In both cases, after registration, when admin goes to admin section >  Customers > Manage Customers

when admin clicks on "Search "

it lists all the users, and in the "Registration date" it shows the date and time of registration

but when we checkout the database, the "Registration date" for the same use is a future date which is completely different from the "Registration date"getting displayed in the manage users section.

It seems like when we save time zone of the store, it shows according to the time zone but actually it is saving incorrect date and time in the database - I am calling it a BUG because the "Registration date" in the database is getting saved as future date and time:

For example: i am in eastern time zone, if a customer registers on the website at 7pm

in the database the "Registration date" is getting saved as 11pm which is not even the current time and is future date and time.
13 anos atrás
in database datetime is stored in UTC.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.