Iam generating a simple report in jasper studio and im using mysql database.
I have a date field in mysql it is in Current_Timestamp.
But during ETL process some fields are filled with (0000-00-00 00:00:00) when i run the report it will give "Unable to get value for field 'date' of class 'java.sql.Timestamp" error.
Can anyone help me please??
Thanks in advance.