-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Hibernate, MySQL and Timestamp (GMT)
PostPosted: Tue Jun 10, 2008 6:18 pm 
Newbie

Joined: Sat Dec 02, 2006 1:09 am
Posts: 12
We have a date that is stored as a timestamp column type in MySQL in GMT (env var TZ is set to "GMT").
We do a query based on the stored timestamp as compared to now (converted to GMT) but
the query does not return anything, but it should.

The only theory we have is that now, after being converted to GMT is being converted back
to local time by Hibernate.

Does hibernate convert either one of the dates/times into local time before comparison?

If so, how do we tell hibernate to not do anything at all with the date (do not convert to local time)?


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.