Jump to content
Changes to the Jaspersoft community edition download ×

Date differences


ggovedar

Recommended Posts

Strange date problem between iReport 1.3.1 and jasper server 1.2

 

If I execute the same report a date field comes back different, in iReport I get back 18/04/07 00.00 executing exactly the same report on the server I get back 17/04/2007 22.00.00

 

I've even tried getting the report from the server via the plugin and execute and the difference is still there!

 

Anyone has any idea what is going on here?

 

Thanks

 

Goran

Link to comment
Share on other sites

  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Hi,

 

This has to do with timezones. There are different places in JS where one could specify the timezones to be taken into account.

On one hand we deal with the timezone at login time.

Secondly, there is also the possibility to specify the timezone for the data source, if the data stored in that particular database that we report out of does not store GMT based datetime information but rather timezone based datetimes.

iReport does not perform any timezone transformation on the data passed back and forth. If you think what iReport produces is OK, then you need to check JS for the mentioned timezone settings to make sure they do not cause unnecessary timezone transformations.

 

I hope this helps.

Teodor

Link to comment
Share on other sites

Hi,

 

thank you for the fast reply!

 

I did look at the timezone info in JS, my data source is at Europe /London Greenwich Mean Time... which should be correct as I am in London..

 

This is also the timezone on the Login screen..

 

Is there anywhere else where the timezone info is stored?

 

The database is storing real times, not offsets, and the correct date/time should be 18/04/2007...

 

Any other suggestions would be much appreciated

 

Thanks,

 

Goran

Link to comment
Share on other sites

  • 8 months later...

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...