There seem to quite q few places where date format is not being applied.
Schedule_job : Info Tab (start date, last start date next run date)
Run log (log date, required start date, actual start date)
Any place where toad makes a conversion, it uses different format :
for example TO_DATE(‘12/16/2015 16:59:00’, ‘MM/DD/YYYY HH24:MI:SS’),
that leads to odd situation where selecting queue_table I see some columns in my predefined date/time format,
but payload is containing bunch of expressions like one above for each of the dates.
The same applies to export data set to insert statement
Is it possible to make it consistent and use the same setting or provide new one for specific information if necessary.