Re: simple date question
From: <edwards_at_garland.dnr.state.sc.us>
Date: 1997/06/12
Message-ID: <339FE7B1.2BE1_at_garland.dnr.state.sc.us>#1/1
Date: 1997/06/12
Message-ID: <339FE7B1.2BE1_at_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 CEST