Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: need some help with oracle 9i (i'm a beginner..)
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...Received on Wed Jul 09 2003 - 09:05:25 CDT
> 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?
>
>
![]() |
![]() |