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