Re: dates
From: Thomas Bierhance <Bierhance_at_orbital-computer.de>
Date: Wed, 02 Jun 1999 21:36:14 +0200
Message-ID: <375587AE.1F33C742_at_orbital-computer.de>
Date: Wed, 02 Jun 1999 21:36:14 +0200
Message-ID: <375587AE.1F33C742_at_orbital-computer.de>
> select * from table where initial_date < '01-Jan-99' and final_date >
> '01-Jan-99';
>
[Quoted] try the to_date function: to_date ('01-Jan-99', 'dd-mon-yy' Received on Wed Jun 02 1999 - 21:36:14 CEST