×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




Hi Buck

In 7.3 it is possible to specify the number of fractional seconds, as IBM calls it, in a TIMESTAMP data type in RPG. It can go out to 12 decimal positions. Default is 6.

I'm not on 7.3 yet, so I haven't tested it. But this down to picoseconds.

There is apparently (google for timestamp and nanoseconds) an ISO 8601 standard that address this stuff. And apparently Java 8 can handle nanoseconds.

Db2 at 7.3 also supports these fractional seconds.

Regards
Vern

On 12/21/2017 8:49 AM, Buck Calabro wrote:
On 12/21/2017 9:16 AM, Luis Rodriguez wrote:

Excuse my ignorance but, What do you mean with timestamp " isn't enough any
more (no ns support)"?
TIMESTAMP records down to the microsecond (us - the 'u' is supposed to
emulate the Greek letter mu), and with a fast processor it is possible
to commit a pair of transactions in the same microsecond. If TIMESTAMP
resolved nanoseconds (ns) then that 'uniqueness' would be restored for
another few generations of processors :-)



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.