[resolved] Syntax error when using global variable in where clause

[Anonymous]

I am trying to use a global variable as part of my where clause in a JDBCInput component.  I want to select all records where the LOAD_TS (load date) is greater than the minUpdateDate (my global variable) --i.e. the last time the job ran.
I can't seem to get the syntax right, i think it should be something along these lines but i get the following errors.  Can anyone assist?
"select * from OPUB_WXDM_TM_PD tm
where tm.LOAD_TS> 
TO_DATE(' "
+  TalendDate.formatDate("MM/dd/yyyy HH:mm:ss", (Date)globalMap.get("minUpdateDate"))
+ "  ', 'MM/DD/YYYY HH24:MIS')" 

[Anonymous]

i was able to reformat the input date and now good to go thank you!