ops I deleted the other one

anyways it should be smth like


define s_srd1=srd1
define s_spool=c:\tmp\monitor\
column today new_value _date
select to_char(sysdate, '_yyyy_fmmonth_dd') today
from dual;

spool xs_spoolxs_srd1x_DATE

x indicates an ampersand