[#4761] - timezone conversion in group by day (URGENT)

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Bug report
Project: Severity:
Component: Reproducibility:
Assigned to:

Dear Japser,

We are using AWS Jasper server (version 6.0.1). The time in Redshift database and Jasper server are both UTC. We'd like to show the time with Australia/Sydney time, so I added Australia/Sydney to the timezone list in applicationContext.xml and restarted tomcat. Then I log onto the web with Australia/Sydney timezone.

There is a record, the column created_on is 2015-05-10 23:12:46 (UTC) // Corresponding Sydney time is next day: 2015-05-11 09:12:46.

I can see the time is converted to Sydney time if I show the details of this record, but If I use "Group by day" for the this column, the day is "2015-05-10" (should be "2015-05-11" Sydney time). If I use "Group by hour of day", the result is right: 2015-05-11 09 AM.

In the JDBC connection screent of Data Source, "Use Database Setting" is selected for time zone. Our database is redshift which does not support tmestamps with time zones. We put UTC timezone in redshift. I tried changing the setting in Data Source to "UTC", but the result is same.

Can you please have a look with priority. Thank you.

Do you have higher version Jasper server for AWS and this bug may be solved?



chelsea.wyb's picture
Joined: Apr 27 2015 - 12:30am
Last seen: 7 years 1 month ago

1 Comment:


Any update please?