minnoleo Posted July 6, 2009 Share Posted July 6, 2009 Hi all, I have a debian 5.0 where I have installed tomcat 5.5, sun java 1.6 and jasperserver 3.1. Reports including date field show a date one day before the real date present in database. I have tried to change java, but the result never change. The same report with ireport give the right result.Can anyone help me please??Thank in advance. Link to comment Share on other sites More sharing options...
minnoleo Posted July 6, 2009 Author Share Posted July 6, 2009 I have solved setting blank in datasource definition. Link to comment Share on other sites More sharing options...
minnoleo Posted July 6, 2009 Author Share Posted July 6, 2009 the time zone Link to comment Share on other sites More sharing options...
chenny Posted August 29, 2009 Share Posted August 29, 2009 Suggest to check on FAQ.Most of us is defaultly set db server to localtime and JVM's timezone is defaulted to CET (unawared).You need to change these parameters to GMT as well in jasperserver otherwise it won't work correctly.The best solution is to convert your date/timestamp into text in SQL..... then In your reports convert text back into date. rgds 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