James Skemp's StrivingLife

The following article covers the timestamp format specifiers accepted by Microsoft Log Parser.

Date

• Year
  • y, yy, yyy, yyyy = last 1, 2, 3, or 4 digits, relative to 2000
• Month
  • M = no leading zero
  • MM = leading zero
  • MP = leading space
  • MX = no leading zero, or with or without zero when parsing
  • MMM = 3-character abbreviation
  • MMMM = full name of month
• Day
  • d = no leading zero
  • dd = leading zero
  • dp = leading space
  • dx = no leading zero, or with or without zero when parsing
  • ddd = 3-character abbreviation
  • dddd = full name of day

Time

• Hour
  • h or H = no leading zero
  • hh or HH = leading zero
  • hp or HP = leading space
  • hx or HX = leading zero, or with or without leading zero when parsing
• Minute
  • m = no leading zero
  • mm = leading zero
  • mp = leading space
  • mx = leading zero, or with or without leading zero when parsing
• Second
  • s = no leading zero
  • ss = leading zero
  • sp = leading space
  • sx = leading zero, or with or without leading zero when parsing
• Millisecond
  • l = no leading zero
  • ll = leading zero
  • lp = leading space
  • lx = leading zero, or with or without leading zero when parsing
• Nanosecond
  • n = no leading zero
  • nn = leading zero
  • np = leading space
  • nx = leading zero, or with or without leading zero when parsing
• Other
  • tt = AM/PM
  • ? = space, or any character (wildcard) when parsing
  • any other character, not listed above, is listed verbatim 

For more about Log Parser, visit LogParserPlus.com.