[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
|
[birt-report-designer-dev] DateTime parameter drops the time
|
- From: SohoSteve <sschwartz@xxxxxxxxxxxx>
- Date: Tue, 7 Aug 2007 13:30:32 -0700 (PDT)
- Delivered-to: birt-report-designer-dev@eclipse.org
I have two DateTime parameters, startDate and endDate.
They are referenced in my SQL query in
myrec.timestamp between ? and ?
One parameter (startDate) is also referenced in
select ? from dual, ...
In all cases, only the date portion of the parameter (enclosed in single
quote marks) is sent to the MySQL engine, as shown by
SHOW FULL PROCESSLIST
The time portion is simply dropped.
Any ideas?
Thanks,
Steve
--
View this message in context: http://www.nabble.com/DateTime-parameter-drops-the-time-tf4232572.html#a12041920
Sent from the Eclipse BIRT - Report Designer - Dev mailing list archive at Nabble.com.