Inserting datetimeoffset's using microsoft sql server produces inconsistent results

[nicoleepp]

Example, when running locally:

julia> using ODBC
julia> dsn = ODBC.DSN("MSSQL-test", "SA", "YourStrong!Passw0rd")
julia> ODBC.execute!(dsn, "drop table if exists test1")
julia> ODBC.execute!(dsn, "create table test1 (test_datetimeoffset datetimeoffset)")
julia> ODBC.execute!(dsn, "insert test1 VALUES ('2016-01-01 01:01:01-05:00')")
julia> source = ODBC.Source(dsn, "select * from test1")
julia> data = Data.stream!(source, Data.Table)
(test_datetimeoffset = Union{Missings.Missing, ODBC.API.SQLTimestamp}[2016-01-01T00:01:01])

But when running the same thing on docker I get:

(test_datetimeoffset = Union{Missings.Missing, ODBC.API.SQLTimestamp}[2016-01-01T06:01:01])

[quinnj]

Sorry for the delay in responding to this; is there a way you could try to reproduce this on master? A big refactor was just merged, so I wonder if things got tidied up enough to fix something like that.

[nicoleepp]

Sorry I don't have the same setup as before so I'm not sure how to reproduce this anymore

[quinnj]

Ah shucks; sorry for the delay and not following up on this sooner.