× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@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-2024 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.