When you use an Oracle date column in an Order By clause,
the Oracle server ignores the time portion of the date. To
include the time, you need to do this:
Order by To_Char(date_itm,'YYYYMMDDHHMISS')
This feature is only available in Forms. (I'm using version
4.5.6.0.7). In SQL/Plus, the time is included in the sort,
even without the extra To_Char function.
I think this is about the best hidden feature in Forms, yet ;-)
Or am I missing something here? If I should be doing something
differently, could someone please help me out?
Regards,
Steve Cosner
