In manipulation of dates when you do substrings or formats
to_char(time,'DD-MON-YYYY')
I always see the following sort order

03-JAN-2002
02-JUL-2002
03-MAR-2002

cause it gets sorted on MON. How can I make this correct according to the
calendar ?
Thanks
Steff DeUnger



Oracle LazyDBA home page