Re: ODBC, STORED PROCEDURES AND DATES

Use the TO_DATE() function to explicitly declare the date format.

-sm

On Fri, 12 Sep 1997 10:06:03 -0400, Daniel Moy <daniel_moy_at_merck.com> wrote:

>I am having trouble getting an ODBC call to stored procedures with Date
>arguments to work. I have created a simple stored procedure that does
>nothing but try to except a date argument. I have tried many different
>ways of inputting the date.
>'09/09/96'
>'09-AUG-97'
>{ts 09-AUG-97}
>
>etc...
>
>I want to use Oracles standard data type so that I can get datatype
>checking on the function/procedure call.
>
>With the MSODBC driver I get the error: {2.00.006325}
>22008[Microsoft][ODBC driver for Oracle]Datetime field overflow.
>
>With Oracles driver I get the error: {2.00.0301}
>22008[Oracle][ODBC driver for Oracle]Invalid date, time or timestamp
>value.
>
>Does anyone have any input/suggestion?
>
>
>
> The contents of this message express only the sender's opinion.
> This message does not necessarily reflect the policy or views of
> my employer, Merck & Co., Inc. All responsibility for the statements
> made in this Usenet posting resides solely and completely with the
> sender.
Received on Sat Sep 13 1997 - 00:00:00 CEST