Oracle 8.1.5 and JDBC Problem

From: Alexander Ohr <a.ohr_at_seeburger.de>
Date: 2000/03/09
Message-ID: <38c79dc9@dns.alvarem.com>#1/1

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 - 00:00:00 CST