1 Reply Latest reply on Aug 22, 2006 2:00 PM by draves

    HEX timestamp in AS/400 QHST

      I wrote the following page against the QHST History Log files on the AS/400. When I don't have a WHERE clause the extraction of the timestamp ends up in the 1870s but the calculation in ColdFusion seems right. When I limit the records selected as below both seem to give dates that match each other to the second but are off by up to half a minute from looking at the output of the DSPLOG program . Is there a better way to do the Hex conversions and get high numeric precision?

      http://publib.boulder.ibm.com/infocenter/iadthelp/v6r0/index.jsp?topic=/com.ibm.etools.ise ries.orxw.doc/orxw_ref369.htm
      http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad min/r0000835.htm