Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Azure SQL - Fractional second precision exceeds the scale specified in the parameter binding #373

Open
kmatt opened this issue Jan 19, 2023 · 0 comments

Comments

@kmatt
Copy link

kmatt commented Jan 19, 2023

Inserting data into an Azure SQL database with executemanycolumns, columns of type datetime and datetime2:

Traceback (most recent call last):
  File "/home/kmatt/projects/test/.venv/lib/python3.10/site-packages/turbodbc/exceptions.py", line 45, in wrapper
    return f(*args, **kwds)
  File "/home/kmatt/projects/test/.venv/lib/python3.10/site-packages/turbodbc/cursor.py", line 242, in executemanycolumns                                                                                                                                           set_numpy_parameters(self.impl, split_arrays)
turbodbc_intern.Error: ODBC error
state: 22008
native error code: 0
message: [Microsoft][ODBC Driver 18 for SQL Server]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.

Perhaps a regression of #47 ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant