I have a log file from McAfee Web gateway that has a date in format [27/Aug/2012:11:50:22 -0600]. What format should I set up for the DateTime mapped attribute in Resource Activity Attributes screen?

asked 16 Jan '13, 03:30

Amit's gravatar image

Amit ♦♦
1662413
accept rate: 100%


Refer to http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html

[27/Aug/2012:11:50:22 -0600] = [MM/dd/yyyy:HH:mm:ss Z]

The brackets will be taken as literals and the Z signifies the time zone

link

answered 16 Jan '13, 03:33

tgulati's gravatar image

tgulati ♦♦
2061411
accept rate: 14%

this is a real common question

you can also try your formats at http://www.fileformat.info/tip/java/simpledateformat.htm beforehand to avoid a bunch of guesswork if you new to data formats

link

answered 16 Jan '13, 11:08

anjan's gravatar image

anjan ♦♦
1112311
accept rate: 22%

2001.07.04 AD at 12:08:56 PDT -> yyyy.MM.dd G 'at' HH:mm:ss z

link

answered 02 May '13, 11:09

Praful's gravatar image

Praful ♦♦
1264923
accept rate: 5%

link

answered 02 May '13, 11:11

Praful's gravatar image

Praful ♦♦
1264923
accept rate: 5%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and 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:

×3
×2
×2
×1

Asked: 16 Jan '13, 03:30

Seen: 1,730 times

Last updated: 02 May '13, 11:11