Re: Datestamp ?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 3 Nov 1999 09:27:45 +0100
Message-ID: <7vorov$l17$1@oceanite.cybercable.fr>

If i clearly understand you want a datestamp in the name of your spool file. You can try something like:

Column d noprint new_value date_
Select to_char(sysdate, 'YY_MM_DD_HH24_MI_SS') d from dual;
Spool file_&date_
...

--
Regards
Michel

Moonez <moonez_at_my-deja.com> a écrit dans le message : 7vojrl$8gu$1_at_nnrp1.deja.com...
> If I run a SQL query I would like to datestamp the file I spooled to.
> Is this possible?
> And if,how?
>
> Thanx
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 03 1999 - 02:27:45 CST