Re: Oracle timestamps (sysdate)
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 11 Dec 1998 22:21:57 +0100
Message-ID: <74s2dl$n6p$1_at_newton.a2000.nl>
Date: Fri, 11 Dec 1998 22:21:57 +0100
Message-ID: <74s2dl$n6p$1_at_newton.a2000.nl>
dean wrote
>Does anyone have an explanation?
Are you sure you inserted the full timestamp? When some are the same, then there is no guarantee in which order Oracle selects the data.
>Also, does Oracle only store time down to
>1/100 of a second
No, only up to whole seconds. I guess you need an aditional column and a sequence number to get the correct order.
Arjan. Received on Fri Dec 11 1998 - 22:21:57 CET