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

Home -> Community -> Usenet -> c.d.o.misc -> Re: simple date question

Re: simple date question

From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/06/12
Message-ID: <339FE7B1.2BE1@garland.dnr.state.sc.us>#1/1

Scott Urman wrote:

> If you bind using the date type, you must enter a date in the proper format.
> Check out Chapter 3 of the OCI manual where the format is described. For example,
> the century and year bytes are in excess-100 notation, and the hour, minute and
> second bytes are in excess-1 notation. Oracle does not validate the dates you
> insert in this manner - you are FAR better off inserting using the TO_DATE
> function and binding a character string in the desired format.
>

You mention an OCI manual, where can I get one? Received on Thu Jun 12 1997 - 00:00:00 CDT

Original text of this message

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