Jump to content
Changes to the Jaspersoft community edition download ×

Convert date format for SQL


sr.spammail2

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...