Originally posted by: SystemAdmin

Hi,

I am using DTX 8.0.2 and I am trying to get the value from JMS header timestamp field. The data is in Java millis time value and has anyone tried to convert it to W3C format? Or any other format?

The value I get is <Timestamp>1220576445733</Timestamp> and when I tried to use NUMBERTODATE(), it just shows ######## in the output.

Any helps would be greatly appreciated.

Thanks
Tina
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: janhess

You are just passing the value to the function?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Hi janhess,

I am going to pass the timestamp and insert to Oracle database table. The column is defined as timestamp, thus, I am thinking to convert it to a proper date/time format before I insert.

Thanks
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: janhess

NUMBERTODATE works on the number of days since December 31, 1864 so your value is far to large to work with it.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

A Java timestamp (as I understand it) is the number of milliseconds that have passed since Jan 1, 1970 00:00:00. I've been trying to find a way to convert those milliseconds into a valid date time that can be of some use, but it's eluding me ...

Maybe some combination of MOD commands to get the days, minutes, etc.?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange