Change the date format to julian and sort it that way.

Just a thot,
Ruth
----- Original Message -----
From: "John DeUnger" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, March 28, 2002 7:14 PM
Subject: Sorting dates


>
> 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 documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page