1 Reply Latest reply on Mar 26, 2008 10:19 AM by Pete Muir

    Internationalization, Date, MySQL

    Drew Kutchar Newbie

      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