Re: HELP - Insert value date format needed

You can also use the ISO (I belive) format :

{d'DD-MM-YYYY'} for dates, {ts'DD-MM-YYYY HH:NN:SS} for timestamps.

This is independent of the database default date.

Daniel Reis

Jerry Gitomer <jgitomer_at_erols.com> wrote in message news:81d9cd$jei$3_at_autumn.news.rcn.net...
> 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 Wed Nov 24 1999 - 16:31:00 CST