I always use "sysdate" for this column
Can you show us how you do that (via sql literal, via
java PreparedStatement.setDate() or via via java PreparedStatement.setTime())?
So it seems Oracle doesn't distinguish "sysdate" to narrow down to second level.
It does. When using ORDER BY LOG_TIME DESC, Oracle will use the date and the time to sort.
To help us, can you please show some results for this query where the sorting order is returned incorrect:
Regards, Jan
[ November 21, 2007: Message edited by: Jan Cumps ]