Skip to Content.
Sympa Menu

freetds - Timestamp fields.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tim Uckun <tim AT diligence.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Timestamp fields.
  • Date: Tue, 27 Feb 2001 11:31:28 -0700


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

The following query also fails with Document contained no data error

select * from tblClients where id = 657


Using freetds cvs snapshot --with-tdsver=4.2 php4.04 and the sybase functions

If I build tds with version 7.0 only the casting as varchar works casting as datetime causes a numeric overflow

Also the bit fields still don't work properly with tdsver=7 both when bit fields are true.

:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered the risks of a bad hire.





Archive powered by MHonArc 2.6.24.

Top of Page