How to convert time format of 2014-10-22 15:32:00 to 10/22/2014 15:32:00

[chanfoli]

You can convert your field to epoch then to desired format with something like this:

| eval epochtime=strptime(your_current_time_field, "%Y-%m-%d %H:%M:%S")| eval desired_time=strftime(epochtime, "%m/%d/%Y %H:%M:%S")

[richgalloway · Accepted solution]

eval t=strftime(strptime(<your datetime field>, "%Y-%m-%d %H:%M:%S"), "%m/%d/%Y %H:%M:%S")