Refine your search:

Log entries have timestamps with Taiwan years. Taiwan year = current year-1911, so this year is 99. By default Splunk sees the time as the year 1999 and shows old data

990413 10:14:25  = April 13, 2010 10:14:25

Is this something I can use datetime.xml for? Maybe an offset?

asked 13 Apr '10, 07:24

dskillman's gravatar image

dskillman ♦
5371413
accept rate: 29%


One Answer:

I don't know of a way to have it read that. Splunk uses strptime, plus a few additions (like %Z, %3N, and I think it might be able to pick up hexadecimal epoch time) but I am not aware of a way to offset dates or times at index time.

link

answered 13 Apr '10, 14:03

gkanapathy's gravatar image

gkanapathy ♦
32.4k4827
accept rate: 41%

It can definitely pick up hex epoch time.

(14 Apr '10, 03:23) dskillman ♦
2

Support for offsets (or taiwanese years) would be an enhancement request. For this case you might be able to get away with a strptime that ignores the year, with a TIME_PREFIX that skips past it (be sure your regex doesn't fail next year when they go to 100). We should be able to default to the current year. Untested. 4 digit years are highly recommended. Sounds like Taiwan will go through this learning experience next year.

(17 Apr '10, 00:14) jrodman ♦
Post your answer
toggle preview

Follow this question

Log In to enable email subscriptions

RSS:

Answers

Answers + Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×100
×41

Asked: 13 Apr '10, 07:24

Seen: 435 times

Last updated: 13 Apr '10, 14:03

Copyright © 2005-2012 Splunk Inc. All rights reserved.