MySQL Hibernate Problem
When entering a date into a MySQL database through hibernate, the date is eventually changed to be one day before the one originally entered. I can't think of anything that might be doing this, could someone offer a suggestion as to a solution? I find this problem very odd, and don't know where to start from. I'm hoping someone has experienced the same thing or can guess at possible problems that I can investiage.
Thanks
[440 byte] By [
mon.goosea] at [2007-11-27 11:36:02]
# 1
Doublecheck the differences in time zones of the client, appserver and DB server. Also investigate the actual value of the date in the database.
If the time is entered in GMT+1 and the server is located in GMT, then the time will be one hour prior.
For example 2007/07/24 00:00:00 would become 2007/07/23 23:00:00 and will be stored as 2007/07/23.
# 2
How do I set the dates of the different aspects of the application?
When I enter a date, the backing bean reads it correctly, and enters it into the database, which records it as one day behind.
For example, in a text field specifying dd/mm/yyyy format,
I enter: 29/7/2007
When the view page shows up, it reads July 29, 2007, which it is reading from the set variable.
Refreshing the page (and forcing it then to read from the database) has the value of July 28, 2007
When looking at the MySQL database, the 29/7/2007 is stored as 2007-07-28
I'm guesing this is a problem in the database's settings? I can't find a way to access these though, any suggestions?
Thanks
