Re: Raw unformatted Timestamp in Rtv Journal Entry

Here is the number

UNFORMATTED_TIMESTAMP = 10611840837506760704

This is a 20U 0 number not a time or a timestamp field. It comes from
the API and I need to convert it to a human readable format.

Thanks,

Marvin
------------------------------

message: 3
date: Wed, 23 Feb 2011 11:51:15 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>
subject: Re: Raw unformatted Timestamp in Rtv Journal Entry
(QjoRetrieveJournalEntries) API

Marvin

Can you paste an example of the number here? And maybe the hexadecimal
form? I'm wondering if it is the MI TOD format, which is an 8-byte
value. Then we can give an API to convert it.

Vern

On 2/23/2011 11:39 AM, Marvin Radding wrote:

I am attempting to use the Retrieve Journal Entry
(QjoRetrieveJournalEntries) API. Everything is working fine but I am
having trouble finding the correct API that will convert the

Unformatted

Time Stamp to a readable form.

The documentation say: The time stamp is in machine readable format

and

can be used as input to a time conversion API, which will convert it

to

a human readable format. I have searched the API for V5R4 but I have
found no API that even hints that it can convert this unformatted time
stamp to a human readable format.

Does anyone have any experience or code that will convert this 20U0
number to a human readable format?

Thanks,

Marvin

------------------------------

message: 4
date: Wed, 23 Feb 2011 09:53:10 -0800
from: Denny Ray <DennyRay@xxxxxxxxxxxxx>
subject: Re: Raw unformatted Timestamp in Rtv Journal Entry
(QjoRetrieveJournalEntries) API

it doesn't happen to look like an "*ISO0" timestamp does it?
20110223095135000000
what would be '2011-02-23-09.51.35.000000' in "*ISO"

On 2/23/2011 9:39 AM, Marvin Radding wrote:

I am attempting to use the Retrieve Journal Entry
(QjoRetrieveJournalEntries) API. Everything is working fine but I am
having trouble finding the correct API that will convert the

Unformatted

Time Stamp to a readable form.

The documentation say: The time stamp is in machine readable format

and

can be used as input to a time conversion API, which will convert it

to

a human readable format. I have searched the API for V5R4 but I have
found no API that even hints that it can convert this unformatted time
stamp to a human readable format.

Does anyone have any experience or code that will convert this 20U0
number to a human readable format?

Thanks,

Marvin

------------------------------