Support mssql's DateTime2 type via chrono

[milgner]

There was some previous conversation about it in #1251 but I didn't find any code in the current version of the repository to get it working. So I wrote my own version, based on the implementation from the go-mssqldb library.

Unfortunately, In order to add it to have a full integration test for type casting, I had to add chrono to the dev-dependencies in Cargo.toml. And since one cannot have features with the same name as a dependency, I had to rename the feature from chrono to with_chrono.

Any suggestions for improvement welcome.

[milgner]

Simplified the code to not require lazy_static, added working tests and fixed a bug with scale>5 along the way. Let me know if you'd like to change anything.

[milgner]

I further improved the implementation by decoding datetime2 as chrono::NaiveDateTime instead and adding support for datetimeoffset, too, which is treated as chrono::DateTime with proper offset information. Suggestions for additional improvement welcome.

[Dessix]

@milgner It appears that the only flaw here is a lack of a cargo fmt run before all checks would pass; Can we try to get this merge-ready before it drifts too far from master?

Additionally, whether this is done in this PR or otherwise, enabling the chrono types in /sqlx-core/src/any/types may now be viable, and would allow use of the any feature with chrono.

[milgner]

@milgner It appears that the only flaw here is a lack of a cargo fmt run before all checks would pass; Can we try to get this merge-ready before it drifts too far from master?

Of course! I haven't had a chance this week to check on this but I'll gladly run it through cargo fmt and rebase it!

Additionally, whether this is done in this PR or otherwise, enabling the chrono types in /sqlx-core/src/any/types may now be viable, and would allow use of the any feature with chrono.

Not sure what the implications might be here. I think I'll try creating a separate branch and create a second PR for that.

[zibebe]

Any possibilities to get this merged?

[milgner]

I see that there are merge conflicts again. I can quickly resolve those if desired. But a short :+1: or :-1: would be appreciated so I don't have to resolve them anew every second week :wink:

[zibebe]

I really hope you get some 👍 for this. With #2073 it's the only thing preventing me from using sqlx for mssql.

[abonander]

Thank you for taking the time to open this PR. However, we're now in the process of splitting out the MSSQL driver for our SQLx Pro offering and it will be rewritten from scratch to fix some longstanding issues, so we will not be accepting your contribution at this time.

We'll make sure that the new MSSQL driver supports the datetime types via chrono and time