>
>
> Hi,
>
> sorry for disturbing...
In the future, please contact [EMAIL PROTECTED] for these types of
questions.
>
> We recently switched from Adabas-D to SAP-DB whose 'native' Perl
> interface is ODBC. Even though SAP-DB supports the same internal date
> and time formats 'YYYYMMDD' and 'HHHHMMSS' as Adabas-D, the DBD::ODBC
> driver does not allow these formats. Appearantly the DBD::ODBC driver
> expects ISO date/time formats 'YYYY-MM-DD' and 'HH:MM:SS'.
>
> Is there any way to tell the driver to take different
> date/time format?
> Such a function would greatly reduce the effort to port our
> software to
> SAP-DB. I've checked the docs and searched the web but have found
> nothing that would help me.
DBD::ODBC passes whatever you pass to the driver manager, which passes
it to the driver. You could try a few things, depending upon which
version of DBD::ODBC you are using (the latest (1.04) is assumed for
these suggestions):
1) if you are using bind parameters, tell DBD::ODBC that the
column is a character one (SQL_VARCHAR). That will force the driver to
parse the string, instead of forcing the ODBC standard date format.
2) if you are not using bind parameters, then check the driver
itself and feel free to get dbi-users/me involved in with the driver
experts to determine what can be done.
Thanks,
Jeff
