Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is this time zone on a data source? Why are the dates in my report off by a day?

April 26, 2017Data dates report source time zone

0

Posted

What is this time zone on a data source? Why are the dates in my report off by a day?

1 Answer

0

Posted

JasperServer can convert date/time values from the database server time zone to a different time zone for your reports, like you store dates in the database in GMT, but want to display them in some other time zone. You do this by setting the time zone for the report unit JDBC or JNDI data source. In most cases, you don’t need to set the time zone on the data source. Dates will appear in the database server time zone. If you do set a time zone on the data source in error, you will see dates being displayed incorrectly by 1 day.