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

Support DATE and DATETIME with TDS protocol 7.3 #36

Open
brendanlong opened this issue Apr 26, 2021 · 0 comments
Open

Support DATE and DATETIME with TDS protocol 7.3 #36

brendanlong opened this issue Apr 26, 2021 · 0 comments

Comments

@brendanlong
Copy link
Contributor

In TDS protocol 7.3, FreeTDS starts returning dates as SYBMSDATE (40) and datetimes as SYBMSDATETIME2 (42). These are unhandled so the wrapper raises:

Freetds.Dblib.nextrow: dbcoltype not handled (C stub)

Unfortunately, I'm not really sure how to make this work. I tried adding these types to the SYBDATETIME conversion section, but I got all dates returned as 1900-0-01 (Microsoft's date zero).

Just creating this in case someone else knows how to make this work.

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