Re: Sysdate in Filename for spool Command

Thomas Kindermann wrote:

>Hi,
>another question, i hope it is the last:
>
>How can i use the spool command with the sysdate function ?
>
>Thanks
>
>Thomas Kindermann
>Oracle Admin
>
>
Making a wild stab at what you are asking as your question is very ambiguous and you
have not included any version information.

SELECT TO_CHAR(SYSDATE, 'MM/DD/YYYY')
FROM some_table;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)