FreeTDS Development Group

[Ole Hansen <oha AT city.dk>]

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