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

Show:
Michael Born
June 21, 2019, 11:25 PM

I’ve run into both of these issues as well. Can we get any official comment on this?

Gary Stanton
October 13, 2019, 1:14 AM

Just adding my +1 to this. Currently having to mess around quite a bit to make use of this datatype in my application.

 

Assignee

Unassigned

Reporter

John Berquist

Labels

None

Priority

New
Configure