tag:blogger.com,1999:blog-19558777.post2405944243677843412..comments2010-07-16T00:48:37.425-04:00Sarath Chandra Panduranginoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-19558777.post-5429099206702956742010-07-16T00:48:37.420-04:002010-07-16T00:48:37.420-04:00Srinivas,<br /><br />It is strange issue. I would look at two things.<br /><br />1. Logic that is storing converting to GMT. Put it good test. , serialize it to string, pass over a webservice. As long as you are using the SAME (inverted ofcourse) logic to read back the date, You should not have <br /><br />2. Run select query in sqlplus (no jdbc there). and see the out put. It might just be that display is GMT+1.<br /><br />Also Note: DATE datatype is not safe to store Timezone information in oracle. Use TIMESTAMP instead. Some oracle db versions have TZ information also storable. they have a default (database TZ) set. You be carefull around thatSarath Chandra Pandurangihttp://www.blogger.com/profile/11373676873027898680noreply@blogger.comtag:blogger.com,1999:blog-19558777.post-90051045182259549512010-07-15T17:42:38.730-04:002010-07-15T17:42:38.730-04:00Hi Sarath<br /><br />I have a question, am using hibernate hbm config to read/write oracle database. I have a DATE datatype that stores date &amp; time in oracle table and in java java.utils.date. Programatically am converting java date object to GMT and trying to store in database. But always datetime is stored as GMT +1hr. In hibernate hbm config type=&quot;timestamp&quot; &amp; sql-type=&quot;date&quot;.<br /> <br />Requirement is to store datetime in GMT. Note that not all datetimes in system are stored in GMT.<br /><br />Appreciate your help!<br /><br />thanks and regards,<br />SrinivasSrinivashttp://www.blogger.com/profile/01961562470942470093noreply@blogger.comtag:blogger.com,1999:blog-19558777.post-12344485753196022142009-04-15T03:34:00.000-04:002009-04-15T03:34:00.000-04:00The Code snippets given do the exact thing. <br /><br />Consider the first snippet,<br />in your case, You have to set networkCal to GMT+02:00 <br />your userDate is in GMT+01:00.<br /><br />Ex: a time of 2009-04-15 12:00 GMT+01:00 (user date) after doing<br /> ps.setTimestamp(2, new Timestamp(userDate.getTime()), networkCal);<br /> will evaluate to store "2009-04-15 11:00:00" in the DB [observe - it doesnot store Timezone info, format may change based on your db]. Which is what you want.Sarath Chandra Pandurangihttp://www.blogger.com/profile/11373676873027898680noreply@blogger.comtag:blogger.com,1999:blog-19558777.post-30339437902385383842009-03-26T08:57:00.000-04:002009-03-26T08:57:00.000-04:00Hello,<BR/><BR/>I have a question - what about a situation when I want my date 'face value' not to be converted to the given in the calendar timezone but i want to store the date with the specified timezone in the database? The timezone on my machine is GMT+01:00 and the same id DBTIMEZONE but i want to store timestamp with timezone = GMT+02:00? Is it possible?<BR/><BR/>Regards,<BR/>AniaAnnahttp://www.blogger.com/profile/01530429172017051270noreply@blogger.com