Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Comparing Date - Problem
assuming the DBA understands dates and data modeling ;-)
"Alan" <alan_at_erols.com> wrote in message
news:bnrrhg$154pfp$1_at_ID-114862.news.uni-berlin.de...
> 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:57:01 CST