explicitly name the columns and do an explicit date conversion from a
string. eg:
INSERT INTO TEST(name,day) VALUES ('some_name',
to_date('12/15/1900','mm/dd/yyyy')
You can look up the format masks in the documentation in the SQL reference
manual.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"jdk" <dsa_at_adfs.it> wrote in message
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 - 09:05:25 CDT
