跨年度日期计算的批处理
2013-01-17 13:23:57| 分类:
桌面应用
| 标签:
|举报
|字号大中小 订阅
setlocal EnableDelayedExpansion
set year=%DATE:~0,4%
set month=%DATE:~5,2%
if "%month%"=="01" goto a
goto b
:a
set/a pravyear=%year%-1
set pravmonth=12
goto e
:b
set/a pravyear=%year%
set/a pravmonth=%month%-1
if %pravmonth% LEQ 9 set pravmonth=0!pravmonth!
goto e
:e
echo %month%
echo %pravmonth%
set starttime='!pravyear!-!pravmonth!-10 00:00:00'
set endtime='!year!-!month!-09 23:59:59'
echo %starttime%
echo %endtime%
osql -U sa -P Tspiral -d aida32 -Q "delete from printlog where timegenerated >= %starttime% and timegenerated <= %endtime%"
E:\command\logparser\logparser -i:EVT -o:SQL -server:127.0.0.1 -database:aida32 -driver:"SQLServer" -username:sa -password:****** -createTable:ON "select * into printlog from SYSTEM where sourcename = 'Print' and eventID = '10' and sid <> 's-1-5-18' and timegenerated >= %starttime% and timegenerated <= %endtime%"
endlocal
评论这张
转发至微博
转发至微博
评论