2 Replies Latest reply on Nov 7, 2002 10:35 PM by Andreas Groeschl

    how can i save timestamp in oracle

    Andreas Groeschl Newbie

      how can i save timestamp as date type in a oracle8 database ???

      in the standardjbosscmp-jdbc.xml i found the following info:

      <!--
      | Note that you lose granularity here
      | Use a numeric type and store milliseconds if you really need it
      -->
      <java-type>java.sql.Timestamp</java-type>
      <jdbc-type>TIMESTAMP</jdbc-type>
      <sql-type>DATE</sql-type>


      What is granularity?
      in the section of mysql or db2 i didn't founde a note above them.