Metricbeat SQL module date fields

As mentioned at similar question posted a few days ago, you can use runtime fields in Kibana through the Create field option in Data Views where you can use Painless to interact with your data to format a date.

Peek 2022-03-08 17-40

If you want to do that at ingestion time you can set up an ingest pipeline to generate your date fields using also Painless.