Re: HELP - Insert value date format needed

From: Benjamin R Heath <benheath_at_uswest.net>
Date: Tue, 23 Nov 1999 21:19:37 -0600
Message-ID: <cHI_3.2137$1A1.55882@news.uswest.net>

Use TO_DATE("01-01-70", "MM-DD-YY"), you can also use several different formats. See documentation on the TO_DATE function.

DF wrote in message <3839e841.69018799_at_news.gte.net>...
>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 Tue Nov 23 1999 - 21:19:37 CST