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: putting a date into a export file on NT

Re: putting a date into a export file on NT

From: Mike Rose <mmrose_at_home.com>
Date: Mon, 29 Mar 1999 07:31:54 GMT
Message-ID: <K%FL2.17407$573.7087@news.rdc1.md.home.com>


Try using this as a *.cmd in concert with your Base filename(s).

echo off
for /f "tokens=2-4 delims=/ " %%i in ('date/t') do set mmddyyyy=%%i%%j%%k set yymmdd=%mmddyyyy:~6,2%%mmddyyyy:~0,4% echo %mmddyyyy%
echo %yymmdd%
Pause

When run it produces the following:

03291999
990329

Take you pick

Mike Rose

Ross Cuthbertson <cuthberr_at_unisys.com> wrote in message news:7dn6jm$ice$1_at_mail.pl.unisys.com...
> I normally put the date into export dump files that we produce every night
> from our development DB's, but now we have NT and this does not seem to
be
> as easy as with UNIX scripts.
>
> Could someone give me a pointer as to how this might be done. Is there a
way
> to format the date?
Received on Mon Mar 29 1999 - 01:31:54 CST

Original text of this message

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