how do I go about doing this?

e.g.

spool filename_TODAYS_DATE.lst

SELECT xxxxxxx

spool off