Re: Date/Time Granularity?
From: Chris Jack <chrisj_at_pro-data.demon.co.uk>
Date: Fri, 27 Aug 1993 20:48:18 +0000
Message-ID: <746484498snz_at_pro-data.demon.co.uk>
Date: Fri, 27 Aug 1993 20:48:18 +0000
Message-ID: <746484498snz_at_pro-data.demon.co.uk>
In article <DAVIDM.93Aug25133535_at_malibu.consilium.com> davidm_at_consilium.com writes:
>Is it true (as it appears to be from the documentation) that Oracle Date/Time
>granularity is only down to the second? How do people handle more demanding
>requirements (like audit trails for for databases with high transaction
>rates)?
>--
I don't see how it could be less than one second on a Unix platform
as Unix (except Solaris) doesn't support finer granularity. Relying
on time alone for audit trails is quite dangerous in any case.
How about using a SEQUENCE.
-- Chris JackReceived on Fri Aug 27 1993 - 22:48:18 CEST