Re: SQL query

From: ST <tansokching_at_hotmail.com>
Date: Tue, 20 Nov 2001 10:09:48 +0800
Message-ID: <9tce24$u3g$1@clematis.singnet.com.sg>

if your end_date is in this format YYYYMMDD,

use min(to_date(end_date,'YYYYMMDD'))

longinus <longinus_at_zeus.polsl.gliwice.pl> wrote in message news:3BF9B6B3.FB1741FF_at_zeus.polsl.gliwice.pl...
> there is a problem as the End_date field is a string-type, and it seems
> as it compares only first two digits of the string. how to make oracle 8
> to compare the whole string?
>
> longinus schrieb:
> >
> > How to choose using SQL language the record that has status 'not
> > reached' and the minimal end_date?
> >
> > table description:
> >
> > SQL> desc t_milestones
> > Name Null? Type
> > ------------------------------- -------- ----
> > NAME VARCHAR2(50)
> > DEADLINE VARCHAR2(10)
> > END_DATE VARCHAR2(10)
> > STATUS VARCHAR2(15)
> > MILESTONESID NOT NULL NUMBER(5)
> > PROJ_ID NUMBER
Received on Mon Nov 19 2001 - 20:09:48 CST