first we want to chagen the NLS_date_format to DD-MON-YYYY HH12:MI:SS AM(using script)SQL> select sysdate from dual;
SYSDATE
---------
17-APR-18
1 row selected.
SQL> alter session set nls_date_format = 'DD-MON-YYYY HH12:MI:SS';
Session altered.
SQL> select sysdate from dual;
SYSDATE
--------------------
17-APR-2018 01:51:42
1 row selected.
Files are saved exactly where you nominate them, eg
SQL> spool c:\temp\my_output.csv
SQL> spool c:\temp\other\my_output.csv
If you don't nominate a path, then typically it will be in the current directory or the "start in" directory for the shortcut on Windows,