SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sort date by week AND year

831088Jan 18 2011 — edited Jan 18 2011

How do I sort a bunch of date by week number and year? I have a bunch of date in the format IW-YYYY such as

45-2010
46-2010
47-2010
48-2010
49-2010
50-2010
51-2010
52-2010
01-2011
02-2011

If I sort by week, I get the following which is not what I want. I want the above.

01-2011
02-2011
45-2010
46-2010
47-2010
48-2010
49-2010
50-2010
51-2010
52-2010

Thanks,
SM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2011

Added on Jan 18 2011

6 comments

523 views