How to convert string type to timestamp


(ssh) #1

hi there

i would like to convert string type to date timestamp

i create log_timestamp field and others below msg by using grok filter
eg log_timestamp : 2018-09-18 14:14:49,036, log_level : WARN , log_type: Test Request

2018-09-18 14:14:49,036 (null) 32 WARN : V21.TestHelper : TestPage :: cde233w4qvqggy012l0gx4j3 :: Test Request : <TestRequest><Version>2.0</Version>; : 30632979ms

problem is that i would like to get date type for log_timestamp field
currently it's string type but i don't want to override default @timestamp
plz point out to me about it

thank you!!!


(Magnus B├Ąck) #2

Use a date filter to convert the timestamp into a canonical ISO8601 timestamp that ES will automatically recognize as a timestamp.


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.