freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: datetime problems

From: Brian Bruns <camber AT ais.org>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: datetime problems
Date: Tue, 27 Mar 2001 23:01:12 -0500 (EST)

Are you running on a big-endian platform? If so, what service pack are
you running on the SQL Server?

Brian

On Tue, 27 Mar 2001, Mark J. Lilback wrote:

> 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.
>
>

datetime problems, Mark J. Lilback, 03/27/2001
- <Possible follow-up(s)>
- Re: datetime problems, Brian Bruns, 03/27/2001
- Re: datetime problems, Mark J. Lilback, 03/27/2001
- Re: datetime problems, Brian Bruns, 03/27/2001
- Re: datetime problems, Mark J. Lilback, 03/28/2001
- Re: datetime problems, Brian Bruns, 03/29/2001
- Re: datetime problems, Mark J. Lilback, 03/29/2001
- Re: datetime problems, Brian Bruns, 03/29/2001