Re: HELP: Adding date to spool filename using SQLplus

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 26 May 2003 20:05:05 -0700
Message-ID: <92eeeff0.0305261905.367b911c@posting.google.com>

"Dave" <dave.news_at_btinternet.com> wrote in message news:<batu8n$mgs$1_at_hercules.btinternet.com>...
> I would appreciate assistance.
>
> From an SQLplus session on my Windows NT PC, I wish to spool a file onto the
> Windows NT PC with a filename that includes the current date (and time if
> possible).
>
> Eg. Sample20030525.csv (nameYYYYMMDD.csv) or Sample20030525155623.csv
> (nameYYYYMMDDHHMMSS.csv)
>
> Is it possible to do, easily, and if so how? The date and time could be
> either the time that it began to spool, or the date and time it stopped
> spooling.
>
> Many thanks,
> Dave.

Goto http://otn.oracle.com/support/tech/sql_plus/htdocs/runtime2.html#spool_date and look at item 22.

Regards
/Rauf Sarwar Received on Mon May 26 2003 - 22:05:05 CDT