Timestamp Manipulation possible?

[mjoc13]

Hi all,

Since i do not know the proper way of handling timezones in ireport, i'm wondering if i can add 8 hours to the utc timestamp coming from the datasource, to offset the default timezone formatting.

Currently it's stored with time 00:00:00 UTC, so converting with out current timezone pulls it back into the previous day.

I tried creating a variable and using the method setHours(int), but when compiling the report is errors with a cannot convert void to timestamp...since the setHours does not return anything. I've also tried casting it to a timestamp after the set method with no luck.

Any info would be appreciated.

 

Thanks,

[svenn]

Look at the capabities of your database. You may be able to manipulate that value in your SQL.

[pawankumar.singh]

use this function at SQL level

to_timestamp(to_char(to_date('01-01-1970 <Time what want  to add>' , 'DD-MM-YYYY HH24:MI:SS')+open_date/(60*60*24),'DD-MM-YYYY HH24:MI:SS'), 'DD-MM-YYYY HH24:MI:SS') 

as per you requirment add you time in below format like below

5:30:00 in my it works

hope it will help!

Thanks 

Pawan