hi,

iam using java,hibernate,mysql


i am storing date which contains 19-10-2008 (of type java.sql.Date) (TIMEZONE GMT) to mysql DATE field.

but when i retrieve the same date from mysql to java by means of object it is being displayed as 18-10-2008 18:30:00 GMT :(

this is how the date property (of retrieved object) has mapped to hibernate type
<property name="pdate" type="date">
<column name="pdate" length="0" not-null="true" />
</property> .



i could not able to figure out what is going wrong . can any one please guide me on What can go wrong in above scenario?


--rama

i figured out the root cause of the problem and resolved the issue

1) Java TIME ZONE is GMT ------------------- storing DATE (2008-10-19 which is in GMT )

2) storing the above date in GMT to mysql

3) MYSQL TIME ZONE IS GMT+05:30

4) as mysql time zone is GMT+05:30 it is viewing the date as (2008-10-19) @ GMT+05:30

5) when i retrieved the date from mysql (GMT +05:30) -----------Java (GMT)
2008-10-19 @ GMT+05:30 ------------ 2008-10-18 18:30 (GMT)
converted to


the above is the reason why it is printing the previous day date.

So how to fix it??

HI...mlavannis

plz check following url regarding setting the timezone in mysql

http://stackoverflow.com/questions/9309 ... e-of-mysql

bye.tc.