Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Birt changes date retrieved from database
Migrateduser
<p>Hello.</p>
<p>
We just noticed that Birt changes in certain cases the date field value in the report.</p>
<p> </p>
<p>For example:</p>
<p>If the date in the field named "sulkemispaiva" is in format '2015-04-20 23:59:59.999' in the database, it is shown as April 21, 2015 12:00:00 AM in Birt.</p>
<p> </p>
<p>I was using a different time format (showing only the date). After changing format datetime to style showing also the time (12. October 2015 16.27.31 UTC+3), I noticed that whenever the time stamp of the field is 23:59:59.999 Birt (I guess) rounds it up to the next day 12:00:00 AM.</p>
<p> </p>
<p>How can I "tame" BIRT and keep the date as it is in the database? Only date is relevant in this case, not the time..</p>
<p> </p>
<p>Thanks in advance, Elja</p>
Find more posts tagged with
Comments
There are no comments yet