Skip to Content.
Sympa Menu

freetds - datetime problems

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mark J. Lilback" <mark AT lilback.com>
  • To: freetds mailing list <freetds AT franklin.oit.unc.edu>
  • Subject: datetime problems
  • Date: Tue, 27 Mar 2001 20:01:24 -0500


Has anyone else run into problems with using SYBDATETIME values?

I'm talking to SQL Server 7 using TDS 4.2 and everytime I use dbdata to get a value as TDS_DATETIME, the structure seems to be reversed (i.e. the first 32 bytes are the time and the last 32 bytes are the days). SYBDATETIME4 works fine, but not SYBDATETIME.

I was going to add code to swap these two, but I wanted to confirm that this is a problem and I'm just not seeing something correctly.

Thanks.

--

__________________________________________________________________________
"The best assumption to have
Mark J. Lilback is that any commonly held
<mark AT lilback.com> belief is wrong." -- Ken Olsen,
http://www.lilback.com/ founder, Digital Equip. Corp.




Archive powered by MHonArc 2.6.24.

Top of Page