MS SQL Server DATETIMEOFFSET fields are not currently cast to a native Lucee type
Description
Currently if you query a SQL Server database table that has a DATETIMEOFFSET column, the returned query will include instances of the microsoft.sql.DateTimeOffset class rather than native Lucee dates. Also it doesn't seem possible to insert into such a column while using a timestamp query param as the timezone offset information is lost. One can insert a ISO8601 string and this is correctly parsed by SQL Server, but unfortunately SQL Server expects a `:` between the hours and minutes of the timezone offset, and the dateTimeFormat() function doesn't include this when choosing `iso8601`.
It would be nice if this SQL data type were more fully supported.
Activity
Just adding my +1 to this. Currently having to mess around quite a bit to make use of this datatype in my application.
I’ve run into both of these issues as well. Can we get any official comment on this?