Can not convert the value of 07/242008 12:00:00:000 AM to Datatype.

bmil

Hi!

Data source is Oracle 10g DB. My data set is:

select t.* from dk_all_dw t
where dat_preseka=?
and vp_koda='KBMR'
and stev_vp> 10000

dat_preseka is Date type in DB.

1) When I set up input parameter type to DateTime in DataSet parameter form, I've got following errors:Can not convert the value of 07/24/2008 12:00:00:000 AM to Datatype.

2) If I set up the input parameter type to Date in base DataSet parameter form and everything is OK. In report parameter date parameter is DateTime type.

3) If data source is mysql everything is OK.


Thanks

Boris




data set for date parameter:

select distinct dat_preseka dat_preseka
from dk_all_dw

report parameter:

dat_preseka is set to DateTime type.

mwilliams

Hi Boris,

What does the data look like when it comes in from the database?