Re: need some help with oracle 9i (i'm a beginner..)

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Wed, 9 Jul 2003 16:02:09 +0200
Message-ID: <MPG.19763ecb2aaa0ed19896b2@iww.cacti.ch.alstom.com>

In article <TKTOa.158641$Ny5.4513915_at_twister2.libero.it>, dsa_at_adfs.it says...

[...]

> ..and then i try to insert something in, i'm not able..
>
> INSERT INTO TEST VALUES ('some_name', '??????')
>
> ..i've tried with a lot of combinations to enter some date, but it doesn't
> accept.. i've searched for some information, but hadn't found out..

try using the to_date function:

INSERT INTO TEST (name, day) values ('some_name',to_date('09-JUL-2003 16:00:00, 'DD-MON-YYYY HH24:MI:SS')); HTH

-- 
mfg
Marc Eggenberger

Received on Wed Jul 09 2003 - 09:02:09 CDT