Re: Comparing Date - Problem

Many developers do not understand how Oracle deals with dates, so, rather than admit they don't know something and ask for help, they work around it by using VARCHAR2 and NUMBER datatypes. All they succeed in doing is making a huge mess of things and problems for anyone down the road who needs to query or sort based on the date.

This is one reason why the DBA should be (but often isn't) included in a project from inception.

"Tom Miskiewicz" <miskiewicz2_at_yahoo.com> wrote in message news:bnphoi$j2i$1_at_news.gatel.net...
> Richard,
>
> > Are you sure the STARTDATE column is a DATE data type? Do a describe on
> > the TEST table.
>
> The application server I'm using shows it as a data, BUT in the database
> it's a number field.
>
>
> Thanks
> Tom
>
>
>
Received on Thu Oct 30 2003 - 14:15:44 CST