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.