Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: Adding date to spool filename using SQLplus

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@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 - 15:11:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US