Mike Lambert writes: > I have been trying to use the following code to update a Sybase > table with a TIMESTAMP column. I first tried not putting the > date_stamp column in the insert and the ODBC driver gave a error. > Next, I tried to put the date_stamp TIMESTAMP column in the query with > a valid timestamp in it and the ODBC driver complained with the > following error: > DBD::ODBC::st execute failed: [Sybase][ODBC Driver][Adaptive Server > Anywhere]Restricted data type attribute violation: Cannot convert to > a timestamp (SQL-07006)(DBD: st_execute/SQLExecute err=-1) at
For Sybase ASE (the "big" database server) a "timestamp" column has nothing to do with an actual date/time. It's just an 8 byte binary value that can be used to check if a row has been updated (i.e. it automatically changes when the row is updated). I don't know ASA, but it's possible that in this case the "timestamp" again isn't what you think it is... Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] *or* [EMAIL PROTECTED] http://www.mbay.net/~mpeppler International Sybase User Group: http://www.isug.com
