Toad World® Forums

Please Help : QSR displaying date and time differently to standard Toad (execute compile statement)


#1

I am executing the following basic query and noticed a difference between OSR and Toad Debug : Select * from

where field = <&&param>;

I noticed the date and time fields in QSR it will put DD-MMM-YY but in toad it will be dd/mm/ccyy hh:mm:ss AM/PM.

I require the toad setting, can anyone help?


#2

A collegue of mine has answered my question :

Add the following line to the script to put into the same format

ALTER SESSION SET nls_date_format = ‘dd-mm-yyyy hh:mi:ss AM’;