We're updating the issue view to help you get more done. 

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.

Status

Assignee

Unassigned

Reporter

John Berquist

Labels

None

Priority

New