JasperSoft Studio - How to handle DateTimeOffset

Refresh

April 2019

Views

101 time

1

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