Re: HELP: Adding date to spool filename using SQLplus

From: Dave <dave.news_at_btinternet.com>
Date: Tue, 27 May 2003 20:11:27 +0000 (UTC)
Message-ID: <bb0gpf$ibo$1_at_sparta.btinternet.com>


Thanks.

"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message news:92eeeff0.0305261905.367b911c_at_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 Tue May 27 2003 - 22:11:27 CEST

Original text of this message