log parser doesn't interpret dates correctly
When I query our IIS logs, I get a value of '30/12/1899' in the date column.
select * from 'C:\IIS 2013 Logs\*.log'
However for some rows, it does have a valid date. (Coincidently rows that
have a day number less than or equal to 12) So immediately you can tell
it's a date formatting issue.
Our IIS is logging in american date format (mm-dd-yyyy) - I cannot change
this. Our server however runs on UK date format (dd-mm-yyyy).
Is there an extra argument I can give log parser so that it grabs the
dates correctly from our americanized logs?
No comments:
Post a Comment