-
Notifications
You must be signed in to change notification settings - Fork 22
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
Support for datetimeoffset? #7
Comments
Thanks for bringing this to our attention @fpauser. We will investigate further, but I would not be surprised if this column type is not supported by the Erlang ODBC library. More about
More info on the type on Microsoft Docs. |
Seems like odbc-support for current sqlserver features is quite limited. Not being able to query |
Yeah, the Erland ODBC application has very limited support for non-standard column types. You would need to either patch Erlang OTP or write your own driver to use instead of ODBC. The latter is what https://github.com/livehelpnow/tds tried but that project hasn't been maintained in a long time, which speaks to the complexity of the task. We unfortunately have no plans to undertake either of these pieces of work but we'll gladly cooperate with anyone who is willing to do so. |
I have opened up this issue on the Erlang/OTP bug board. Will try and fix it myself hopefully with a bit of guidance from the OTP maintainers. |
C Data Type Struct for datetimeoffset: https://docs.microsoft.com/en-us/sql/relational-databases/native-client-odbc-date-time/data-type-support-for-odbc-date-and-time-improvements |
hi, i just stumbled upon this issue. FIY, datetimeoffset not supported on python odbc driver either so it's probably not erlang specific :) |
Querying a table with a
datetimeoffset
field gives an error: 'Column type not supported'.Also tested directly with
:odbc
, error persists:Is it really
:odbc.sql_query
that does not supportdatetimeoffset
?The text was updated successfully, but these errors were encountered: