Hi

I am putting the below query in a OLEDB SOURCE through a variable (it is a select statement with a where clause from one date to another).

I am getting through this expression. Can you have a check on it please.I dont know whats is wrong with this expression


"select TestRecordtype, request_id from department

where LOAD_TMSTP between
(select max(END_TMSTP) LOG) and
(TO_DATE("+RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System:tartTime] ), 2) + "-"
+RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , @[System:tartTime] ), 2) + "-"
+RIGHT("0" + (DT_STR,4,1252)DATEPART( "yy" , @[System:tartTime] ), 2) + " "
+RIGHT("0" + (DT_STR,4,1252)DATEPART( "hh" , @[System:tartTime] ), 2) + "."
+RIGHT("0" + (DT_STR,4,1252)DATEPART( "mi" , @[System:tartTime] ), 2) + "."
+RIGHT("0" + (DT_STR,4,1252)DATEPART( "ss" , @[System:tartTime] ), 2) +",'DD-MM-YY HH24.MI.SS')) "

Thanks

If it's meant to be an "Oracle" sql query, It's not! Incorrect (non Oracle) syntax.

I do not recognize it as being valid to Oracle RDBMS.

>System:tartTime
Looks strange to me.
should it be "SystemtartTime" instead?

yes it is start time.
I dont know how it gets misstyped