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

When you enter a date, you can't use a string representation of the date (like dd-mm-yyy), as inside Oracle, daes are represented by integer.

You have to use some function which permits this translation.

Jerome

"jdk" <dsa_at_adfs.it> a écrit dans le message de news: TKTOa.158641$Ny5.4513915_at_twister2.libero.it...
> i'm using oracle 9i
> i need to use dates in my database, but i encountered some problems (the
> language has bit differences with standard sql..).
> so, when i create a table, for example:
> create table TEST (
> Name VARCHAR(15) NOT NULL,
> Day DATE )
>
>
> ..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..
>
> Some one could help me or tell me some url where to find some answer?
>
>
Received on Wed Jul 09 2003 - 07:38:15 CDT