How do I parse a date string?

Follow

Kumar Saurabh

• October 09, 2013 18:15

How do I parse the following?

rangeStartTime='2013-10-09 09:14:49,950',

3

• 

  Kumar Saurabh

  • October 20, 2013 15:48

  It is a two step process - first I had to extract the date string from the log line using a parse operator. parseDate converts the String to a Date object and use toMillis to translate a date into millis. parseDate operator supports the full format supported by java as described  http://docs.oracle.com/javase/1.4.2/docs/api/java/text/SimpleDateFormat.html (if the link does not work, just google for "java date formatter")

  * | parse "*-0700" as datestr
  
  | toMillis(parseDate(datestr, "yyyy-MM-dd HH:mm:ss,SSS")) as dateInMillis

   

   

  0

  Comment actions Permalink
• 

  Charlie Pye

  • March 11, 2014 21:00

  How would I do this with a date formatted as yyyy-MM-dd HH:mm:ss ?  Without milliseconds.

  0

  Comment actions Permalink
• 

  Christian

  • March 14, 2014 02:26

  try this:

  | toMillis(parseDate(datestr, "yyyy-MM-dd HH:mm:ss")) as dateInMillis

   

  chr.

  0

  Comment actions Permalink

Please sign in to leave a comment.