i am having big trouble with the different date formats of iReport and mySQL. In my database i have a format like yyyy-MM-dd and i try to get a start and enddate for the report by prompting for parameters (java.util.date).
After hours of googling i have not found any working solution to this problem using suggested java-objects in the xml file or even the SQL-command Convert() to change the date format before its passed to the database.
Any advice of how to solve this issue would be really apprecicated!
Convert date format for SQL
in Products
Posted
Hi everybody
i am having big trouble with the different date formats of iReport and mySQL. In my database i have a format like yyyy-MM-dd and i try to get a start and enddate for the report by prompting for parameters (java.util.date).
After hours of googling i have not found any working solution to this problem using suggested java-objects in the xml file or even the SQL-command Convert() to change the date format before its passed to the database.
Any advice of how to solve this issue would be really apprecicated!
Thank you!
C.