# Help with converting timestamp
**URL:** https://discuss.elastic.co/t/help-with-converting-timestamp/89215
**Category:** Logstash
**Created:** [June 13, 2017, 2:44pm UTC](https://discuss.elastic.co/t/help-with-converting-timestamp/89215 "2017-06-13T14:44:28Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@pmohan](https://discuss.elastic.co/u/pmohan)
#### Post date: [June 13, 2017, 2:44pm UTC](https://discuss.elastic.co/t/help-with-converting-timestamp/89215/1 "2017-06-13T14:44:28Z")
below is my log line , I use the json filter and that works perfectly fine. I just need to get the log time stamp sorted in a readable format .
timestamp:"unix timestamp, in nanoseconds, when the log message was created"
"timestamp": 1497360775545000192,
trying this and isn't working
mutate {
# rename field from 'name' to 'browser\_name'
rename =\> { "timestamp" =\> "logtimestamp" }
}
mutate {
convert =\> {"logtimestamp" =\> "integer" }
}
date {
match =\> ["logtimestamp", "UNIX"]
target =\> "logTimestamp\_updated"
}
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [June 14, 2017, 5:47am UTC](https://discuss.elastic.co/t/help-with-converting-timestamp/89215/2 "2017-06-14T05:47:38Z")
The UNIX pattern assumes the input is seconds but you have nanoseconds. I suggest you use UNIX\_MS instead and remove the six last digits of `timestamp` to turn it into milliseconds. You can use a mutate filter's gsub option to trim digits off the tail end.
---
### Author:  [@pmohan](https://discuss.elastic.co/u/pmohan)
#### Post date: [June 14, 2017, 2:25pm UTC](https://discuss.elastic.co/t/help-with-converting-timestamp/89215/3 "2017-06-14T14:25:22Z")
Thanks so much for your reply !
It works perfect now!
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 12, 2017, 2:25pm UTC](https://discuss.elastic.co/t/help-with-converting-timestamp/89215/4 "2017-07-12T14:25:34Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.