problem with report parameter date/date time

Hello everybody,

maybe it is a easy problem, but I didn?t find something on this forum.

I have a SQL Database (Firebird or MSSQL). There is a table "date" and something else. For example: ausgabe.jpg

The parameter in my report is the field "aus_datum"

On my personal computer everything works perfect, but if I run the same report on the customer computer I have a problem with "aus_datum"

If the customer types in the report parameter "01.09.2010" the report analysis in the background "31.08.2010"

Or if I make the repot with parameter "date time" and the customers types "01.09.2010 00:00", the report analysis in the background "31.08.2010 22:00"

So I dont know exactly the problem. It is something about GMT+-2:00. Maybe with the locale of apache tomcat, maybe something else, maybe some adjustment on the running server (german version).

I had also tried the preferences in eclipse (look attached file preferences.jpg)

Do you know about this problem?
best regards
Rafael

Find more posts tagged with

Comments

thuston

The timezone difference between logged in user and DB is most likely the cause.

Is BIRT making the change or the DB?

It seems that if they enter a time value the change would be desireable.
However the static date should not lose a whole day.

birtprofi

<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="68171" data-time="1283869519" data-date="07 September 2010 - 07:25 AM">
The timezone difference between logged in user and DB is most likely the cause. 
 
Is BIRT making the change or the DB? 
 
It seems that if they enter a time value the change would be desireable. 
However the static date should not lose a whole day. </blockquote>
 
I think, that BIRT are making the change. I open the report via html link and in the background there run an apache tomcat server. 
Could I make a adjustiment or configuration in the birt report runtime folder. 
 
best regards 
Rafael