Re: DAYOFWEEK Function

From: Anna C. Dent <anacdent_at_hotmail.com>
Date: Tue, 21 Oct 2003 18:02:04 -0700
Message-ID: <gGklb.79762$Ms2.41140@fed1read03>

Alister Taylor wrote:

> 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.

Please note that Oracle is 'picky' when it comes to data types.

'27/OCT/2003' is a STRING; just as is 'ABC'.

You might want to look up the TO_DATE function. Received on Tue Oct 21 2003 - 20:02:04 CDT