Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: putting a date into a export file on NT
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
![]() |
![]() |