I tried checking that (Tools > Preferences > Oracle / Options) option, but then when I used DBMS-Scheduler and clickec on [View SQL] button, I got this error message: "Could not convert variant of type (String) into type (Double)"
If I un-check that option, I get this for the start-date for a job:
"start_date => to_date('12-03-2013 12:50:00', 'dd-mm-yyyy hh24:mi:ss'),"
Here is what I was expecting:
"start_date => to_timestamp_tz('AMERICA/LOS_ANGELES 12-03-2013 13:50', 'TZR DD-MM-RRRR HH24:MI'),"
Did I do something wrong? Please advise.
thanks,
pat