[AccessD] Rounding in SQL Server ODBC

Gustav Brock Gustav at cactus.dk
Tue May 2 08:23:12 CDT 2006


Hi all

My mistake - thought the underlying data type of datetime was double as in Access, but:

<quote>

Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds.

</quote>

Thus, if you wish to store datetime in SQL Server with millisecond resolution you'll have to use double - and run your own converting routines - or leave the date field rounded down to integer seconds and add another field for milliseconds resolution in double or smallint.

/gustav

>>> Gustav at cactus.dk 01-05-2006 18:53:32 >>>
The SQL Server ODBC driver sometimes does some funny rounding when handling doubles:

These are the last decimal part of Doubles. As you can see, they are rounded by 3, sort of.





More information about the AccessD mailing list