Re: oracle sequence numbers

From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Mon, 20 Jan 2003 04:29:36 GMT
Message-ID: <3E2B7AB3.4070102_at_earthlink.net>

Pablo Sanchez wrote:
> 71062.1056_at_compuserve.com (--CELKO--) wrote:

>>>Of course, since fractions isn't mandatory and precision is
>>>implementation defines, one should be very careful... <<
>>
>>True, but the Federal Government FIPS required at least five decimal
>>places in the seconds.

>
>
> I don't know of any vendor that provides that type of precision on
> their timestamp. Can you provide documentation that shows this
> requirement? I'm curious.

Informix database servers have provided 5 decimal places of seconds in timestamps since about 1989. Currently, you have to enable that precision (otherwise you get 0 dp), but it is still available.

-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix 1.04.PC1 -- http://dbi.perl.org/

Received on Mon Jan 20 2003 - 05:29:36 CET

This message: [ Message body ]
Next message: Pablo Sanchez: "Re: oracle sequence numbers"
Previous message: Ann Terrell: "ERD Case Studies - begging recommendation ~"
Maybe in reply to: helen_fearman: "oracle sequence numbers"
In reply to Pablo Sanchez: "Re: oracle sequence numbers"
Next in thread: Pablo Sanchez: "Re: oracle sequence numbers"
Reply: Pablo Sanchez: "Re: oracle sequence numbers"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message