Hi everyone. I'm trying to create a form that retrieve values from a database. The database field has a date/time column that store values in unixtime format. The report created in jasper uses a calendar in witch we select Date and Time. I need a way to convert the values entered in the jasper calendar Date/Time to unixtime so i can build the sql query. The values entered in the calendar are convert to a weird format as can be seen in the pictures below.