set your own format ...
column whichdate new_value whichday noprint
select trunc(sysdate) whichdate from dual;
spool c:\...\File_&&whichday..txt
HTH
Gregg
|
Results 1 to 10 of 10
Thread: Using sysdate in filename
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote