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 - 19:49:39 CST
