Format the way I see AWS Cloudwatch timestamps in Log Insights

Question

Is there a way to show the timestamps in cloudwatch in a friendlier format? If we take a super simple query:

fields @timestamp, @message
| sort @timestamp desc
| limit 200

I get the standard @timestamp column to show:

2022-03-15T13:38:15.567+00:00

Can I have something simple like:

13:38:15

score 3 · Accepted Answer · answered Mar 15 '22 at 13:55

3

You could try using formatting on the timestamp field like in this post.

answered Mar 15 '22 at 13:55

Niketh Sudhakaran

thank's using a datefloor(@timestamp, 1s) does help a lot with readability – iosifv Mar 16 '22 at 11:14

score 1 · Answer 2 · answered Mar 16 '22 at 11:13

Although using datefloor(@timestamp, 1s) helps a lot with readability, unfortunately the official answer is:

Currently, CloudWatch Logs Insights doesn't support filtering logs with human readable timestamps.

2 Answers2