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