Hi, thanks for this answer,
but how can I process a SQL_C_DATE type within a single sql-statement
e.g.
INSERT INTO testtable VALUES ( 1, '01.01.2004')
If I exec this statement I get the following error :
Datetime field overflow;-3048 POS(35) Invalid date format:ISO.
insert into testdatum values (1, '12.12.2004')
Best regards
tom
"Koetter, Thomas Theodor" <[EMAIL PROTECTED]>
11.05.2004 09:39
An: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Kopie:
Thema: RE: odbc driver
Hi Tom
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Dienstag, 11. Mai 2004 07:14
> To: [EMAIL PROTECTED]
> Subject: odbc driver
>
>
> Hi,
>
> are there any plans to modify the odbc-driver to allow other
> date-formats
> than ISO-Date ?
With ODBC you can process any time, date, timestamp format if you
use the appropriated data types like
SQL_C_TYPE_TIME
SQL_C_TYPE_DATE
SQL_C_TYPE_TIMESTAMP
cmp. the ODBC Programmer's Reference, Appendix D: C Data Types.
Online accessible at www.microsoft.com
If you mean the conversion from e.g. date to character, cmp.
Appendix D: Converting Data from C to SQL Data Types, C to SQL: Date
Excert:
When date C data is converted to character SQL data,
the resulting character data is in the "yyyy-mm-dd" format.
HTH Thomas
----------------------------------------------
Dr. Thomas K�tter
SAP AG, SAP Labs Berlin
Do you know SAP^H^H^H MaxDB ? www.sapdb.org
