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?

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 (DOT) com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"jdk" <dsa (AT) adfs (DOT) it> wrote