String manipulation and format them to timestamp

Elastic Stack Logstash
1

Hi guys,

i am new to logstash and i am stuck with following problem:

I have something like a timestamp: 1703220054

First 2 digits indicates year YY 17
Next 2 digits indicates MM 03
Next 2 digits indicates dd 22
Next 2 digits hour hh 00
Next 2 digits minutes mm 54

I want to bring it to timestamp value for @timestamp.

Do you have any good advice for me?

2

Use a date filter with a YYMMddhhmm pattern.

3

Ok, its's that easy :smiley:

Started with substringing, concatenations and formating - too much SQL in my head.

Works like a charm.

Thanks

4

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