Re: SQL

If the date is actually stored in a DATE type then

select min(datefield) from table..

<cava123_at_noos.fr> wrote:

>Hi all,
>I need to write SQL request to find the oldest date in the table ;
>
>For exemple :
>17/12/80
>20/02/81
>28/09/81
>01/05/81
>19/04/87
>17/11/81
>23/05/87
>03/12/81
>
> ==> 17/12/80
>
>Any Help ?
>
Received on Tue Dec 03 2002 - 16:06:57 CST