Hi, I am trying to get localized time based on user's browser clock settings to my report. I am getting time offset from UI to server and can pass it with parameter to my template filling, but it seems I don't know how I could alter the timestamps I am fetching from the database with the offset. I have saved the timestamps in database in GMT time (java.sql.timestamp without timezone). Now I am able to do following (to text field expression): Long.valueOf(($F{gps_datetime}.getTime()+10800)) Which gives me the time in milliseconds with added offset (3 hours in this case), but I don't know how I could convert it back to YYYY-MM-DD HH:MM:SS format.