Hi, I'm having trouble when using DBD::ODBC to query TIMESTAMP(nee datetime) columns from a Sybase database using unixODBC. It looks like the string it gets sprintf'ed to is the wrong size as I get random junk on the end of the time value. I'm using the Openlink 3.2MT drivers which provide good timestamp values when used with unixODBC from C/C++. Heres an example with dbish: denblueuser@dbi:ODBC:SYBTEST> select VALUE_DATE from TRADE_BASIC/ VALUE_DATE '2001-01-02 00:00:00.00.' [snip] When I looked with the perl debugger the final chars were \c@. Has anyone else come across this? Is there a work around? TIA, Alex.
