Re: DATES
From: Javier Rojas <jrv_at_quisar.com>
Date: Thu, 02 Jul 1998 10:36:44 +0200
Message-ID: <359B469C.7737A4CF_at_quisar.com>
Date: Thu, 02 Jul 1998 10:36:44 +0200
Message-ID: <359B469C.7737A4CF_at_quisar.com>
You must use TO_DATE instead of TO_CHAR if the 'the_date' field is of type DATE.
select * from table1 where the_date = to_date('01-07-1998', 'dd-mm-yyyy')
Javier Rojas. Received on Thu Jul 02 1998 - 10:36:44 CEST