FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Tim Uckun writes:
 > It seems that the timestamp fields are not fully supported by free tds and 
 > or php.
 > 
 > the following query fails with "document contained no data" error
 > 
 > select  upsize_ts from tblclients where id=6657
 > 
 > Both of these queries return a blank but at least it does not crash
 > 
 > Select cast (upsize_ts as datetime) as TS from tblclients where id=6657
 > Select cast (upsize_ts as varchar) as TS from tblclients where id=6657

Errmmm... you do realize that a timestamp column is a binary(8) and
that it has no relation to either time or date, right?

Michael
-- 
Michael Peppler - Data Migrations Inc. - mpeppler AT peppler.org
http://www.mbay.net/~mpeppler - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com