timestamp value

Backup and Recovery
IBM iSeries
tips and tricks
Hi, I am receiving TIMESTAMP value from the iSeries system as an unsigned 64 bit integer value. Is it possible to convert this timestamp into a readable format in windows machine? The iSeries timestamp value is an unsigned 64 bit integer value. All the time management routines which I can use on a windows machine deal with signed integer value. So the iSeries timestamp appears as a negative value to the routines like ctime64() or gmtime64(). Any clues? P.Prasad

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can you provide a bit more detail as to where in Windows you are going to be using the value? The solution may be different in .NET vs Excel vs ASP etc..


Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Pprasad123
    I use the timestamp value in .NET environment. Basically, I transfer security journal entries from iSeries to a windows client so that I can do further processing there. The entries are in the form of records with multiple fields. One of the fields is the unformatted TIMESTAMP (system timestamp - DTS) field.
    0 pointsBadges:
  • TomLiotta
    The QWCCVTDT API was first made available in V2R1 of OS/400, so I suspect that the *DTS format is proprietary to OS/400 and isn't in any format that can be handled on any other system. I don't recall ever seeing any description of the *DTS format. AFAIK, that format can only be converted by that API; none of the other APIs for date/time seem to be able to handle it. (APIs might exist; I just don't know of any.) If a *DTS value is needed on another platform, it probably must be converted to a standard form first. IBM probably would find it difficult to change this. Old journals and journal receivers can go back a lot of years. The audit information that is held there must remain consistently accessible into the future. There are a lot of programs that already exist that expect the *DTS format to be sent through QWCCVTDT. And journal information is not intended to be accessible through other platforms. If you want it in Windows, then you are responsible for doing the conversion. Unfortunately, that's about as far as I can go with this. Our company sells products that make entries from QAUDJRN available for 3rd-party consoles such as SiteProtector from ISS for example. So, I can only supply directions that point to IBM documentation. Tom
    125,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: