SQL & PL/SQL

Hello,

my sql script file is,

-----------------------------------------------------------------------------------------------------------------------------------------------

SET heading       ON

SET echo            OFF

SET feedback     OFF

SET trimspool     ON

SET newpage     NONE

SET verify           OFF

SET define          OFF

SET termout        OFF

SET timing          OFF

SET linesize    400

SET pagesize  0

SPOOL check_redo_apply_xxxxxxxxxxxxxx.log

COL current_scn FOR 9999999999999999

SELECT current_scn FROM v$database;

SELECT MAX(sequence#) FROM v$archived_log WHERE applied='YES';

SELECT MAX(sequence#) FROM v$archived_log WHERE applied='NO';

SELECT process,pid,status,sequence#,block#,blocks,delay_mins FROM v$managed_standby;

SELECT sequence#,status,archived FROM v$standby_log;

COL name                   FOR  a24

COL value                   FOR  a12

COL unit                      FOR  a28

COL time_computed   FOR  a20

COL datum_time         FOR  a20

SELECT * FROM v$dataguard_stats;

SPOOL OFF

-----------------------------------------------------------------------------------------------------------------------------------------

please ask 'SPOOL check_redo_apply_xxxxxxxxxxxxxx.log' in 'xxxxxxxxxxxxxx',i wanna to use a date format, how to add in SQL or PL/SQL ?

Thanks!

Regards

QuanwenZhao