LogParser "SELECT TO_TIMESTAMP(date, time) AS utc-timestamp, TO_LOCALTIME(utc-timestamp) AS local-timestamp, c-ip, cs-username, EXTRACT_TOKEN(cs-uri-stem,-1,'/') AS filename INTO DATAGRID FROM \\WEBSERVER\admin$\system32\logfiles\w3svc1\ex07*.log"
参考资料:
IIS Log File Entries Have the Incorrect Date and Time Stamp
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q271196
Thread: Converting IIS Log Time to Local Time
http://forums.iis.net/t/1145241.aspx