On Nov 6, 2017, at 2:47 PM, Max Slimmer <maxslim...@gmail.com> wrote: > > Coincidentally I ran into this issue last week. From what I could gather the > MS SQL data type can accept values with no more than millisecond precision. > This is true using parameterized statements through adodbapi and also T-SQL > and implicit conversion from char to datetime. The type accepts up to seven > places (nano seconds). >
Your post is not exactly correct, and the difference is critically important. The adodbapi happens to display time strings with 7 decimal digits, but that is TOTALLY unrelated to the precision with which the underlying database engine stores its date/time values, or the precision returned by the NOW() function in your database engine. This is not specified by the standard. By default, for example, the MySQL DATETIME time does not store fractional seconds at all. — Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc.
_______________________________________________ python-win32 mailing list python-win32@python.org https://mail.python.org/mailman/listinfo/python-win32