Re: ODBC INSERT with parameter markers and TO_DATE
From: Guy Rouillier <guyr_at_raleigh.ibm.com>
Date: 1998/02/26
Message-ID: <6d43a2$279u$1_at_rtpnews.raleigh.ibm.com>#1/1
Date: 1998/02/26
Message-ID: <6d43a2$279u$1_at_rtpnews.raleigh.ibm.com>#1/1
Mark, thanks for the suggestion. I'm unfamiliar with using escape sequences. Does the C variable containing the intended column contents actually have the curly braces, the 'd' and then the value in single quotes? I'll give it a try.
marktoml_at_gdi.net (mark tomlinson) wrote:
>try using the ODBC data format.
>You can use an ANSI date format via an ODBC escape:
> { d '1981-12-03' }
>Note that this is enclosed in single quotes and always of the format
>YYYY-MM-DD.
Received on Thu Feb 26 1998 - 00:00:00 CET