This is one hell of a question since it touches on so many things (Seam, JPA, Hibernate, JDBC, MySQL) and I couldn't think of a better place to post it. (if this is not the right place for it, then I apologize)
I am in the process of implementing an internationalized system using Seam 2.0, JBoss 4.2.2 and MySQL 5.0. What's the best way to store/retrieve date/time/timestamp values from database.
I know that it is best to store dates in the database in GMT and display them back to the user in user's TimeZone. So the question is how should I do it. Is that the default JPA/Hibernate behavior?
I use java.util.Date for all my dates and use @Temporal(TIMESTAMP) which creates MySQL datetime columns.
Any tip is greatly appreciated
Ask on the hibernate forum about storing the in the database, and here about how to display that information.