@echo off
set /a t=%date:~0,4%%date:~5,2%%date:~8,2%-1
if "%date:~8,2%"=="01" echo 提示:批处理不支持当前日期的处理&echo.&echo.&set /p t=请输入昨天日期(8位,如20090101):
cls
echo.
echo.
echo 当前设定日期:%t%
echo.
echo.
echo 每日数据导入程序
echo.
echo.
echo 5秒后继续......
echo.
call 延时函数.bat
echo.
set /a StartS=%time:~6,2%
set /a StartM=%time:~3,2%
set /a StartH=%time:~0,2%
echo 开始时间:%time%
echo.
sqlplus XXX/XXX@XXX @D:/XXXX.sql %t%
echo.
echo 开始时间:%StartH%:%StartM%:%StartS%
set /a EndS=%time:~6,2%
set /a EndM=%time:~3,2%
set /a EndH=%time:~0,2%
echo 结束时间:%time%
set /a diffS_=%EndS%-%StartS%
set /a diffM_=%EndM%-%StartM%
set /a diffH_=%EndH%-%StartH%
if %diffH_%==1 set /a diffM_=%diffM_%+60
if %diffH_%==2 set /a diffM_=%diffM_%+120
if %diffH_%==3 set /a diffM_=%diffM_%+180
echo 程序运行时间:%diffM_%分钟%diffS_%秒
echo.
echo.
echo.
echo.
pause
-------------------------------------------------------------------------------------------------------------
延时批处理:
@echo off
setlocal enableextensions
echo %time%
call :ProcDelay 400
echo %time%
goto :EOF
:ProcDelay delayMSec_
setlocal enableextensions
for /f "tokens=1-4 delims=:. " %%h in ("%time%") do set start_=%%h%%i%%j%%k
:_procwaitloop
for /f "tokens=1-4 delims=:. " %%h in ("%time%") do set now_=%%h%%i%%j%%k
set /a diff_=%now_%-%start_%
if %diff_% LSS %1 goto _procwaitloop
endlocal & goto :EOF
补充:
延时还可以用ping的方式,如
@ping -n 3 127.0.0.1 > nul
缺点是计时精度不高,只是为了延时的话可以考虑。