Sysdate time-resolution ?
Date: 1996/08/10
Message-ID: <4uj6e6$3ot_at_hasle.sn.no>#1/1
Hello oraclers !
In our transaction-oriented database we need to make a time-stamp for every
recived transaction. As several transactions are beeing processed every second
i need to put hundredths(?) of a second in the timestamp.
Sysdate handles this quite well, but..
Our DB is running on 7.1.6. on Solaris 2.5 on a SS1000 machine.
Thanks in advance !
When I try to select the journal-table order by time-stamp I somethimes get the
wrong answer !
Transactions that i know are arriving in the right order show up as comming
in reverse or any order.
I suspect to_char(time_stamp,'HH24.MI.SS') to be the problem.
It seems to be a problem with transactions within the same second frame.
QUESTION :
Is it possible to get 100.s and 1000.s of a second out of to_char or anyting
else ?
-- ----------------------------------------------------------Received on Sat Aug 10 1996 - 00:00:00 CEST
| Alexander Moan --:-) moan_at_sn.no |
| Any statements I make are my own, and are not to be |
| taken as an statement from my employer. |
| |
| Norwgian Defence Command Norway |
| Home Guard Staff |
| |
| "Don't blame me, I just work here !" |
---------------------------------------------------------