| Queries from Report Builder and Report Engine [message #92412] |
Thu, 17 November 2005 22:06 |
Eclipse User |
|
|
|
I am using the following query with Birt 2.0 M2 release against an Oracle
database. I need to put the to_char in the select statement because Birt is
not picking up the correct date without. This query runs fine when I
preview my results from the datasource. However, this query fails to find
sampletime when it runs in with the Report Engine deployed in a Tomcat.
Both environement have the same JDBC driver. What difference are there
between the Report Builder and Report Engine that may cause this.
Thanks. Bill
select SAMPLEVALUE, to_char(SAMPLETIME,'Mon DD, YYYY HH24:MI')
from PRODUCTIONHISTORY
where SAMPLENAME = 'actualOutput'
and SAMPLETIME > to_date('2005-11-16 6:20','YYYY-MM-DD HH24:MI')
and SAMPLETIME < to_date('2005-11-16 20:00','YYYY-MM-DD HH24:MI')
order by sampletime asc
|
|
|
Powered by
FUDForum. Page generated in 0.06657 seconds
Home