Re: Append date/time stamp to logfile name (NT 4.0)

Chuck,

It's doable, and I've seen scripts on the net that do it, but it's a bit cumbersome. However, you could also do it in sqlplus, using spool, where the name of the spool file is taken from a new_value of a date query, i.e.,

col x new_value fn
select to_char (sysdate, 'DDMMYYYYHHMI') || '.txt' x from dual;

spool &fn

hth,

yosi

"Speaks, Chuck W." wrote:

> OS: NT 4.0
>
> I have scheduled a query against a database that pipes results to a log
> file.
>
> Ex. Select * from any_table; >logfile.txt
>
> Since I need a trend on this query I need to keep the logfile names unique.
> Best case scenario is to append a date/time stamp to the logfile name as in
> 230820011200.txt (daymonthyeartime). Does anyone know how to do this with
> NT scripting? Any help would be greatly appreciated.
>
> Thanks,
>
> Chuck Speaks
> Database Administrator
> Lithonia Lighting
> 770-860-3450
> http://www.lithonia.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Speaks, Chuck W.
> INET: CSpeaks_at_Lithonia.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Thanks,

Yosi


---------------------------------------------------------
Yosi Greenfield
Oracle Certified DBA
ygreenfield_at_compuserve.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).