Birt converts datetime to YYYY-MM-DD 00:00:00.000

shen747

I have a report that accepts a start date and an end date. The two dates are submitted as strings to the birt report and the birt report parameters are also defined as strings. And the report file contains the following prepared <br />
statement :<br />
<br />
[code=auto:0]<br />
select * from autoota_log<br />
where autoota_log.TimeStamp between ? and ? and<br />
autoota_log.Response=?<br />
[code=auto:0]<br />
<br />
From the JSF page I'm formatting and submitting the date time as follows :<br />
<br />
[code=auto:0]<br />
Starting Date : 2008-09-21 00:00:00<br />
Finishing Date : 2008-09-21 23:59:00<br />
[code=auto:0]<br />
<br />
But when the query is being executed by the birt the query is transformed as follows :<br />
<br />
[code=auto:0]<br />
select * from autoota_log<br />
where autoota_log.TimeStamp between '2008-09-21 00:00:00.000' and '2008-09-21 00:00:00.000' and<br />
autoota_log.Response=20<br />
[code=auto:0]<br />
<br />
This happens even though I've specified the type of the report parameters as String Type. Does anyone have any clue as to why this happens ??. I really need to submit the datetime as a string in the query as follows :<br />
<br />
[code=auto:0]<br />
select * from autoota_log<br />
where autoota_log.TimeStamp between '2008-09-21 00:00:00' and '2008-09-21 00:00:00' and<br />
autoota_log.Response=20<br />
[code=auto:0]<br />
<br />
Anyone have a clue as how to correct this and get this done ???.

mwilliams

Hi shen747,

I've not heard of an issue like this with a BIRT parameter before. It may be hard to recreate, but if you can recreate the issue and attach the items in here, that'd be great.