Jasper server TIME ZONE Conversion issue

[balacs11]

Dear All,

I have an issue with the time zone conversion in one of my report.

Database Timezone : UTC

Jasperserver Timezone - UTC

Data source setting : Use database setting - in this case , it is UTC.

I have start date and end date in query which are passed as parameter. even the start time and the end time.

I have  Comapre_date from date base which has to be comapred with the start date/time and end date/time after converting it into CET.

I use this conversion  (FROM_TZ(CAST(Compare_dt AS TIMESTAMP), 'UTC') AT TIME ZONE 'CET' BETWEEN start_dt AND .end_dt)

but the conversion is not happening . It remains the same from database. Is there any issue with this conversion and the jasper time zone??

If I login using "CET" in jasper server , the conversion happening. Anyone has any suggestions why it is happening like this?

 

Regards,

Bala

[lastname]

Timezone in login page will convert every timezone in report. https://community.jaspersoft.com/wiki/time-zone-conversion-jasperreports-server