Re: dates
From: Andreas Polke <A.Polke_at_vwfsag.de>
Date: Thu, 3 Jun 1999 12:28:02 +0200
Message-ID: <7j5lt5$fl61_at_doiftp1.volkswagen.de>
Date: Thu, 3 Jun 1999 12:28:02 +0200
Message-ID: <7j5lt5$fl61_at_doiftp1.volkswagen.de>
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>...Received on Thu Jun 03 1999 - 12:28:02 CEST
>> 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'
>