jahp00 Posted March 4, 2009 Share Posted March 4, 2009 Hi, I got a problem with InputControl/DataType (Date), I select a Date interval startDate endDate but in the report output shows the data with one Day Diference ie:startDate=01-01-2009endDate=01-31-2009 but the report output shows data from 12-31-2008 to 01-30-2009 (I logged the query sended to MySQL and shows the Dates with 1 day diference.)Any idea? Link to comment Share on other sites More sharing options...
jahp00 Posted March 5, 2009 Author Share Posted March 5, 2009 The problem was the datasource time zone, I removed the time zone from the datasource and voilá.. everything OK. Link to comment Share on other sites More sharing options...
benoy13 Posted January 3, 2011 Share Posted January 3, 2011 The issue here is when we select a date interval like 12-31-2008 to 01-30-2009 which should'nt be considering time. Instead it considers the interval as '12-31-2008 00:00:00' to '01-30-2009 00:00:00' and when it converts to local time zone it will always show as one day behind.It doesnt make sense to convert the intervals in date to datetime data type on the inputcontrol with datatype Date. Is this going to be fixed in a future release? Link to comment Share on other sites More sharing options...
baggypants Posted January 4, 2011 Share Posted January 4, 2011 If the data column is in the DB as a Timestamp then this is perfectly expected behaviour. When I have to use timestamp data I edit the query to somthing likeWHERE Timestamp_data BETWEEN $P{startday} AND ($P{endday} + 1 day) 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