Re: HELP - Insert value date format needed

Default date field format is:

        DD-MON-YYYY use:

    INSERT INTO <table_name> VALUES ("01-JAN-1970");

hth
jerry gitomer

Stas Burdan wrote in message <383A17AC.6EF2817_at_mediaone.net>...
|try this:
|insert into table (date_field) values ("11-22-1999")
|use double qoutes.
|Date format depends on value of NLS_DATE*FORMAT*
|(if I recall the name of NLS_* coorrectly)
|
|- Stas
|
|> Hello All,
|>
|> I'm new to Oracle and can't locate the syntax for inserting
data into
|> a date field. Will someone help me out please? I've tried
various
|> combinations of insert into birthday values (1-1-1970); with
no luck.
|> I looked in the online help but can't locate this simple
command.
|>
|> Thanks,
|>
|> Donell
|
Received on Mon Nov 22 1999 - 23:39:49 CST