Re: ordering by weekday

From: gh <schmuel_2000_at_yahoo.com>
Date: Fri, 1 Feb 2002 22:09:47 -0700
Message-ID: <1012625699.471649@nnrp1.phx1.gblx.net>

Just an idea ...

Create another table like

day sortorder
monday 1
tuesday 2
wednesday 3
...

join it to your table by the weekday
and use the sortorder column to sort your result

HTH "Marc E" <jonnycattt_at_cablespeed.com> wrote in message news:u5jspjfqp2su43_at_corp.supernews.com...
> I think I figured it out, but I'm not convinced it will work all the time.
> Will it?
>
> select ...
> from...
> order by to_char(hiredate-1, 'd');
>
>
Received on Fri Feb 01 2002 - 23:09:47 CST