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

Answer 1

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

CloudWatch Insights query: Format a DateTime string for grouping