How to force Oracle Dates not to adjust based on timezone

Issue

Depending on the setup you have between the system where JasperReports Server and the system where reporting database is running, in some cases you may see that Oracle dates returned by queries are incorrect and/or adjusted. This happens becase the time component of the dates gets adjusted based on timezone or Daylight Savings time

Solution

To prevent this from happening on JasperReports Server, add one of the following properties to /WEB-INF/classes/jasperreports.properties file:

net.sf.jasperreports.pattern.timezone=System

or

net.sf.jasperreports.jdbc.time.zone = REPORT_TIME_ZONE

Then save the file and restart the server. Please note that these properties are not available in TIBCO JasperReports^® Server versions prior to 6.1.0

Ref. case #00067618