Re: oracle sequence numbers
From: Alan Gutierrez <ajglist_at_izzy.net>
Date: Sun, 19 Jan 2003 13:23:24 GMT
Message-ID: <gFxW9.25171$I55.621695_at_news2.east.cox.net>
>
> I don't know of any vendor that provides that type of precision on
> their timestamp.
Date: Sun, 19 Jan 2003 13:23:24 GMT
Message-ID: <gFxW9.25171$I55.621695_at_news2.east.cox.net>
Pablo Sanchez wrote:
> 71062.1056_at_compuserve.com (--CELKO--) wrote in
> news:c0d87ec0.0301181712.272c338_at_posting.google.com:
>
>>>> If 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.
[alan_at_maribor alan]$ psql
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
alan=# select current_timestamp;
timestamptz
-------------------------------
2003-01-19 07:29:15.564178-06
(1 row)
Alan Gutierrez - ajglist_at_izzy.net Received on Sun Jan 19 2003 - 14:23:24 CET