This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes GWT and the fly likes Problem with Date and Time Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » GWT
Bookmark "Problem with Date and Time" Watch "Problem with Date and Time" New topic

Problem with Date and Time

ahmad razaa

Joined: Jan 03, 2011
Posts: 10
I am developing a GWT application. I have some input of date and time and save it into the database. When i save the date and time in db, it saves one hour before, even i am saving in the same format to whom i took the input. Kindly help me how can i resolve this problem. I want to save the same date and time to the database so that i can access it into the different reports. Waiting for your quick response.
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 10167

Looks like a time zone issue and/or a difference between the client server times. How are you passing the date/time to the server?

[How to ask questions] [Donate a pint, save a life!] [Onff-turn it on!]
ahmad razaa

Joined: Jan 03, 2011
Posts: 10
Here is the code of the client from where i took the input.

And here is the code on the server where i changed the zone and then save it to database.

If i run this code on local computer then its work fine. but if i run this on my server, then its save one hour before in database. I think its a problem of daylight saving. I tried alot of different ways. But they are not working.
ahmad razaa

Joined: Jan 03, 2011
Posts: 10
But i get the date time in my application it shows the right time. But in database it saves 1 hour before. Actually i am also generating jasper reports from the database, in that reports it always shows 1 hour before. One solution can that i plus one hour in reports but i dont know how can i do that, i didnot find the solution yet..
ahmad razaa

Joined: Jan 03, 2011
Posts: 10
I solved the problem somehow, although its not a good solution but its works for saving the date and time

It save the exact date and time of client. But when i read it from the database and show it in my application it shows 1 hour after this. I think the problem is, the server uses the london time zone when i display it in my application, application opens in copenhagen and it automatically add 1 hour. Please let me know how can i resolve the problem. When i use the same method with the date and time from db it adds two hours. Please let me know any appropriate solution.
Gihan Pandigamage
Ranch Hand

Joined: Aug 23, 2009
Posts: 60
Check both server and local machine time zones. I also had this issue. when I changed time zones of the client machines the problem disappears.
wood burning stoves
subject: Problem with Date and Time
Similar Threads
logic:iterate indexed="true"
Query Optimization
Storing Japanese, from swing input box to MySQL.
EntityManager.find() returns null
Hibernate Multiple Insertion