Never used datetimeoffset. Will need to experiment with it... If the driver doesn't read it properly, perhaps we'll can address that in the adapter code for SQLServer. I'll put it on my TODO.
Andrus > On Sep 30, 2015, at 9:48 PM, Vincent Smith <vinc...@outlook.com> wrote: > > I am using Cayenne 3.0 and Sql Server 2014. I have a column in my sql Server > schema with a type of datetimeoffset. My problem is this. Cayenne can convert > that column into a java.util.Date without error, but I lose the hours, > minutes, and seconds precision. When I try to use java.sql.Timestamp, I get > the following error: > > > java.sql.SQLException: Value 2015-09-28 11:15:18.4170238 -05:00 cannot be > converted to TIMESTAMP. > > > Is there any Cayenne type I can use to convert a datetimeoffset into a java > Timestamp or Calendar object and maintain the hours, mins, and seconds? >