Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple date question
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
![]() |
![]() |