4 replies
by elyazzi Accepted solution
by tony hopkinson Accepted solution
discrepancy. DateTime values are stored as doubles with the fractional part being the number of seconds since midnight.
Hard to say where this is going wrong, but checking the floating point value of the time at source and a good and bad destination might give you a clue.
Have a look for anything that's treating it as a single, also if anything is using variants, converts in them are local to each machine and depend on all sorts of dll hell.
Which is a point actually, a quick check for dll versions across good and bad machines might reveal a common denominator as well.
by elyazzi Accepted solution
by tony hopkinson Accepted solution
The routines to display the data in the browser won't be the same ones that build the report content.
Presumably you are passing a datetime to the report and then formatting in the report.
Try doing the format in the sql
Convert(VarChar(5),[SomeTime],8)
It's not brill but it should give you a cue where to start looking.
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending