Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS returned data lenght????

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ole Hansen <oha AT city.dk>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS returned data lenght????
  • Date: Thu, 16 Oct 2003 00:58:10 +0200

On Thu, 2003-10-16 at 00:41, Michael Peppler wrote:
> On Wed, 2003-10-15 at 15:34, Ole Hansen wrote:
> > Hi,
> >
> > Sorry for the interruption :)
> > I an application I do the following when calculating the time as I want
> > the time to be represented as UNIX-time used in my application:
> >
> > DATETIME:
> > -------------
> > double time;
> > u_int32_t days = *((u_int32_t *)value);
> > u_int32_t msec = *((u_int32_t *)(value+sizeof(u_int32_t)));
> > time = ((double)(days-25567))*24*60*60 + ((double)msec)/1000.0;
> >
> > The day calculated gives me the expected day but the usec doesnt match.
> > This is for CS_DATETIME_TYPE. The calculated value is 8-10 hours behind.
>
> the "msec" value is really 300th of a seconds, not 1000th.
>
> Michael

Oh.. Thanks!
That will give me the needed 8.4 hours I missed :-)

Thanks.
Ole






Archive powered by MHonArc 2.6.24.

Top of Page