Oracle 8.1.5 and JDBC Problem

From: Alexander Ohr <a.ohr_at_seeburger.de>
Date: Thu, 9 Mar 2000 13:49:22 +0100
Message-ID: <38c79e0d@dns.alvarem.com>

Hi,
got a problem with datatype date.
in MsAccess and MsSqlServer it's possible to do a select like this (via Jdbc):
Select cDate from testDate where cDate < { d'2000-03-09 } this doesn't seem to work with a Oracle Database I get an error Message ORA-01861: literal does not match format string.

Is there anybody who can help me solve this problem ?

Or do I need to convert the date like this ? insert into testDate (cDate) VALUES (TO_DATE('09.03.2000 12:13:14', 'DD.MM.YYYY HH24:MI:SS'));
select TO_CHAR(cDate,'DD.MM.YYYY HH24:MI:SS') from testDate;

Is there another possibility, i would prefer a solution as mentioned first with { d' or { ts' ....) ...
Thanx a lot.

Bye
Alex Received on Thu Mar 09 2000 - 06:49:22 CST