| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Appending date to export file name in NT
Put this in a batch file
for /f "tokens=2-4 delims=-/ " %%i in ('date/t') do set filedate=%%i%%j%%k exp / file=<SID>exp_%filedate%.dmp
On my machine this gives "YYYMMDD" but it all depends on the date format setting in the control panel/regional settings. You may also change the order of i, j, k above to achieve the necessary result.
-- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: chris.guidry_at_atcoelectric.comReceived on Tue May 21 2002 - 17:09:03 CDT
> -----Original Message-----
> From: Gene Sais [SMTP:Gsais_at_co.palm-beach.fl.us]
> Sent: Tuesday, May 21, 2002 03:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Appending date to export file name in NT
>
> exp / file=<SID>exp_%DATE%.dmp
>
> >>> TaylorSI_at_mar.dfo-mpo.gc.ca 05/21/02 04:43PM >>>
>
>
> Hi Everyone,
> I can easily append the date to my export file names in unix. Can anyone
> tell me how to do on NT. An example would be great! I've had very little
> NT experience. Thanks for any help.
> Shirley :-)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Taylor, Shirley
> INET: TaylorSI_at_mar.dfo-mpo.gc.ca
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Gene Sais
> INET: Gsais_at_co.palm-beach.fl.us
>
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, Chris INET: chris.guidry_at_atcoelectric.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).
 |
 |