in the date related columns, i am getting values in mm/dd/yyyy format. i need the full datestamp including the hours,minutes and seconds. I tried to change the nls_date_format to include those without success. How to change the format?
I am using 8.0.5 on a digital unix machine
i did change the nls_date_format="MM/DD/YYYY :HH:MI:SS" .
However, the change is not reflected in the values.
I have not restarted the database, as I think this is a dynamically modifiable parameter right?