JasperSoft Studio - How to handle DateTimeOffset


April 2019


101 time


In SQLserver we have this type DateTimeOffset witch the only diferent with DateTime is that we have an Offset of the time zone.

JasperSoft Studio (6.3.0 Final) don´t work with this type as you can see:

java.lang.ClassNotFoundException: microsoft.sql.DateTimeOffset cannot be found by net.sf.jasperreports_6.3.0.final

I can still make it work with the java.sql.Timestamp and apply the timezone of the login.

Of course I don´t know if this is the best way to work with this data type and I´m open to ideas

0 answers