Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Tim Roberts
On Nov 6, 2017, at 2:47 PM, Max Slimmer 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

Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Max Slimmer
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

Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Bob Kline
On Mon, Nov 6, 2017 at 10:07 AM, Vernon D. Cole wrote: > [Sorry everyone. My kitten stepped on the keyboard and sent out a one-letter > reply.] Always good to have helpful assistants. :-) > Yes, patches are accepted and welcome. My last remaining Windows > development

Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Bob Kline
On Mon, Nov 6, 2017 at 9:59 AM, Vernon D. Cole wrote: > On Sat, Nov 4, 2017 at 6:27 AM, Bob Kline wrote: >> >> The adodbapi package does not seem to handle datetime values > > Y You hit the Send button too soon, right? -- Bob Kline

Re: [python-win32] datetime values in adodbapi

2017-11-06 Thread Vernon D. Cole
Y On Sat, Nov 4, 2017 at 6:27 AM, Bob Kline wrote: > The adodbapi package does not seem to handle datetime values appropriately. > > import adodbapi > print(adodbapi.version) > cursor = adodbapi.connect(...) > cursor.execute("CREATE TABLE #t (i INT, d DATETIME)") >