Re: Date problems

Michael Holm wrote
> the user has to enter to dates and
> then select the data between the dates.

    select my_date
    from my_table
    where my_date between date1 and date2;

> My date function includes Name of the day.

I am not sure about the date formats used below. I guess that

    select to_char(sysdate, 'ddd dd mmm yyyy')     from dual;

would get you "Thursday 06 May 1999". If not, check your docs. If so, then you can use something like

    where my_date between

        to_date (date1string, 'ddd dd mmm yyyy' )
        and to_date (date2string, 'ddd dd mmm yyyy' );

Arjan. Received on Thu May 06 1999 - 13:51:49 CDT