Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DATE FORMAT

Re: DATE FORMAT

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 22 Mar 2002 21:51:32 -0000
Message-ID: <3c9ba9dd$1_3@mk-nntp-1.news.uk.worldonline.com>


"harry smith" <hrysmth_at_hotmail.com> wrote in message news:a7g1ng$l77rv$1_at_ID-135545.news.dfncis.de...
> How do I insert values 'AUG 22 2001 12:00AM'
> into a date datatype field?
>
>
> -hsmith
>

Look at the documentation,
and check out the to_date function.
That should give you the answer.

HTH.
Paul Received on Fri Mar 22 2002 - 15:51:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US