How to convert a unix_timestamp field to a new date field

my json log is :

{
"fileid": 203936363,
"timestamp": 1464187170,
"pubTime": 1464172574,
"reads": 111
}

my current filter is:
filter{
date {
match => [ "timestamp", "UNIX" ]
}
}

now i wish copy the "pubTime" to new field "pubTime_new" , look like "May 25th 2016, 18:36:14.000" in kibana, and my timezone is +08:00 "Asia/Shanghai"

hope show results in kibana:

@timestamp May 25th 2016, 22:39:30.000
pubTime 1464172574
pubTime_new May 25th 2016, 18:36:14.000
reads 111

Per https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html

filter{
date {
match => [ "pubTime", "UNIX" ]
target => "pubTime_new"
}
}
1 Like