Skip to content

Instantly share code, notes, and snippets.

@felickz

felickz/IISLogsByUTCDateRange.LPS

Created November 3, 2015 13:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save felickz/5de029f2f6e7d097aeec to your computer and use it in GitHub Desktop.
Save felickz/5de029f2f6e7d097aeec to your computer and use it in GitHub Desktop.
Download ZIP
LogParserStudio - IISLogsByUTCDateRange + AM/PM
Raw
IISLogsByUTCDateRange.LPS
/* 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
@felickz
Copy link
Author

felickz commented Nov 3, 2015

I keep losing this, takes forever to find the date format functions in LogParser

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment