Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP - Insert value date format needed
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)
> 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 - 22:27:24 CST