Skip to Content.
Sympa Menu

freetds - Re: Timestamp fields.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Timestamp fields.
  • Date: Tue, 27 Feb 2001 10:35:12 -0800 (PST)


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




Archive powered by MHonArc 2.6.24.

Top of Page