Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[birt-report-designer-dev] DateTime parameter drops the time

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.



Back to the top