Re: help on date column

From: Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de>
Date: 1997/09/29
Message-ID: <342F3916.D421DCB9@KirchGruppe.de>#1/1

Michael Serbanescu wrote:
>
> ...
>

Of course, this will work. An Oracle teacher gave us another hint: try

select col1, col2 from table_a where sdate < to_date ('01010001', 'DDMMYYYY'); I tried it: works, if you do not use dates before Christ.

---

> Meng Kiat TAN wrote:
> >
> > Hi,
> > I have created an index for a date column in a table. This
> > column is nullable. How do I form up a query so that this
> > query will make use of the index ? I need to select
> > all the rows which have the date field null.
> >
> > select col1, col2 from table_a where sdate is null;
> >
> > This does not make use of the index. So is there a way
> > to avoid doing a full table scan?
> >
> > Thanks & regards!
 

-- 
Martin Haltmayer

Received on Mon Sep 29 1997 - 00:00:00 CDT