1 Reply Latest reply on Nov 15, 2004 3:32 AM by Johan Borchers

    Timestamp issue

    clau25 Newbie

      Something weird happens in my application. I have a timestamp field in a table that has all the time's values set to hour 0 (ex. 2004-11-09 00:00:00.0). When my application loads this field from the database (within a session bean), some of the values have the time set to hour 1 (ex. 2004-11-09 01:00:00.0). This happens just to some values, not to all of them and i could not say what values are loaded with 0 hour and what with 1 hour.

      Any tip would be very much appeciated, i'm kinda lost here,
      Claudia

        • 1. Re: Timestamp issue
          Johan Borchers Newbie

          Be aware of how you fill the CMP field (if you're using CMP). Look at the type mappings in the standardjbosscmp-jdbc.xml file. E.g use a Calendar object in your application to create a correct date and time object (aware of timezone etc.) and use this object to fill a date, time or timestamp field (used by CMP or plain JDBC).

          Johan.