[birt-report-engine-dev] Ref: BIRT Date Configuration

[Pranav <Pranav.Aggarwal@xxxxxxxxxx>]

Hi,
      I was working with BIRT, and stuck with using Date field. The way 
BIRT stores the date is in MM/DD/YYYY HH:MM:SS AM/PM.
The way the Database i.e. Derby, which I am using is in TIMESTAMP format 
i.e. YYYYMMDDHHMMSS. Is there any way this could be worked out and can 
be solved.

What I have worked is like that, I have created Report Parameter and 
defined the date field with default value in MM/DD/YYYY HH:MM:SS AM/PM, 
further I have created Data Set Parameter and configured with the Date 
column from the database (Derby). Then in query kinda I have done like: 
select APP.ACCT_INFO.ACCT_ID, APP.ACCT_INFO.ACCT_HOLDER,
from APP.ACCT_INFO
where APP.ACCT_INFO.DATE_CREATION = ?

The following is the error I am getting:

A BIRT exception occurred.
 Plug-in Provider:Eclipse.org
 Plug-in Name:BIRT Data Engine
 Plug-in ID:org.eclipse.birt.data
 Version:2.1.2.v20070205-1728
 Error Code:odaconsumer.CannotPrepareStatement
 Error Message:Failed to prepare the following query for the data set 
type org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet.
[select APP.ACCT_INFO.ACCT_ID, APP.ACCT_INFO.ACCT_HOLDER,
from APP.ACCT_INFO
where APP.ACCT_INFO.DATE_CREATION = ?]
Error preparing SQL statement.
SQL error #1: Syntax error: Encountered "from" at line 1, column 58.

If any one has any information regarding this, it would be really helpful if you could provide the same.

Regards,

--
Pranav Aggarwal