MikeM19 Posted August 18, 2015 Share Posted August 18, 2015 Hello,I'm new working with Ireports 5.6, i just created a report that extracts some information from a DB using SQL sentencies, the problem i'm facing is that the Date information i'm getting is wrong, for example if i check the "created date" field from the record in the application where we work with those appears like "17/08/15 10:47 AM" which should be the correct date but when i run the report the date appers 5 hours ahead, i mean "17/08/15 03:47 PM" and that happens with all my DB records from different tables, so any of you guys have any clue about this? i hope any of you can put me in the right direction.Best regards! Link to comment Share on other sites More sharing options...
hozawa Posted August 18, 2015 Share Posted August 18, 2015 JasperReports Server's locale probably is set up with a different time zone than your database. Link to comment Share on other sites More sharing options...
Tarun Gupta Posted August 19, 2015 Share Posted August 19, 2015 Hey,,,,U can also set a pattern,,,for the date......thats u want,,,,,,,,, Link to comment Share on other sites More sharing options...
MikeM19 Posted August 19, 2015 Author Share Posted August 19, 2015 Thank you both for the response, the report i'm running is not on the jasper reports server, i'm testing it from my computer i don´t know if that changes something about the locale you're talking about?And Jazz, i'm sorry for the question but what do you mean by setting a pattern? as i said i'm pretty new with ireports so there is some concepts i still don't know about it. Regards! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now