DAYOFWEEK Function

From: Alister Taylor <al_at_irow.com>
Date: 21 Oct 2003 17:31:29 -0700
Message-ID: <78ae4359.0310211631.5b93e247@posting.google.com>

Dear All,

I am having a little (trans: a LOT) of trouble geeting a DayofWeek function to work.

Broadly, this is for a basic flight booking service, which stipulates that a given flight is to be made on a certain daynumber.

A flight may be made on many dates, but must be on this daynumber. I think that the problem may lie in part with the date entered as ie '27/OCT/2003', but this seems not to be causing problems for other people within the group.

Basically, when I use the select query, DAYOFWEEK comes up as an "invalid identifier", running ORacle 9.

What am I doing that is making this newbie feel like an absolute and total cretin?

Thanks,

Alister Received on Tue Oct 21 2003 - 19:31:29 CDT