Re: dates

beautifiying it will result in:

    select * from table where to_date('01-Jan-99', 'dd-mon-yy') between initial_date and final_date;

--
Andreas Polke

VOLKSWAGEN BANK GMBH
I-SBD Informatik Systembetrieb Datenbanken Tel. +49-531-3812
eMail: A.Polke_at_vwfsag.de

Opinions are mine and do not necessarily reflect those of Volkswagen Bank GmbH

Thomas Bierhance schrieb in Nachricht
<375587AE.1F33C742_at_orbital-computer.de>...
>> select * from table where initial_date < '01-Jan-99' and final_date >
>> '01-Jan-99';
>>
>
>try the to_date function: to_date ('01-Jan-99', 'dd-mon-yy'
>
Received on Thu Jun 03 1999 - 05:28:02 CDT