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.
I’ve run into both of these issues as well. Can we get any official comment on this?
Just adding my +1 to this. Currently having to mess around quite a bit to make use of this datatype in my application.