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 also T-SQL
> and impl
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
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 environment (I work mostl
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
http://www.rksystems.com
mailto:bkl...@rksystems.com
___
[Sorry everyone. My kitten stepped on the keyboard and sent out a
one-letter reply.]
Yes, patches are accepted and welcome. My last remaining Windows
development environment (I work mostly on Ubuntu these years) died several
months ago leaving me high and dry to do maintenance. I have purchased
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)")
> cursor.execute("INSERT INTO #t
