Oracle timestamps (sysdate)

From: <dean_at_gfsmortgage.com>
Date: Thu, 10 Dec 1998 22:52:41 GMT
Message-ID: <74pjbp$78j$1_at_nnrp1.dejanews.com>

I have a table used for replication that sorts rows based on a timestamp (sysdate). I have 8 similar rows that all have the same timestamp. The rows are identical except for the fact that one 1 character column in 4 of the rows has a D and the other four have an I.

Any way I try ordering these rows (other than on this one column) gives me the D's before the I's, though I know one of the I's was inserted before a D.  This is important for synchronization.

[Quoted] [Quoted] Does anyone have an explanation? Also, does Oracle only store time down to 1/100 of a second, or can I get even more decimal places?

Thanks for any suggestions,
Dean

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 10 1998 - 23:52:41 CET