Created
November 3, 2015 13:32
-
-
Save felickz/5de029f2f6e7d097aeec to your computer and use it in GitHub Desktop.
LogParserStudio - IISLogsByUTCDateRange + AM/PM
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* LogParserStudio - IISLogsByUTCDateRange + AM/PM */ | |
SELECT TOP 1000 to_timestamp(date,time) as stamp-UTC, * | |
FROM '[LOGFILEPATH]' | |
WHERE to_timestamp(date,time) between timestamp('2015/10/23 07:46:00 AM', 'yyyy/MM/dd hh:mm:ss tt') and timestamp('2015/10/23 07:59:00 PM', 'yyyy/MM/dd hh:mm:ss tt') | |
ORDER BY time ASC |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I keep losing this, takes forever to find the date format functions in LogParser