# Metricbeat SQL module date fields

**URL:** <https://discuss.elastic.co/t/metricbeat-sql-module-date-fields/297348>\
**Category:** Kibana\
**Created:** [February 16, 2022, 10:01am UTC](https://discuss.elastic.co/t/metricbeat-sql-module-date-fields/297348 "2022-02-16T10:01:20Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [March 8, 2022, 4:42pm UTC](https://discuss.elastic.co/t/metricbeat-sql-module-date-fields/297348/2 "2022-03-08T16:42:23Z")

</div>

As mentioned at [similar question](https://discuss.elastic.co/t/metricbeat-sql-module-fields-query-change-to-date-time/296723) 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](https://us1.discourse-cdn.com/elastic/original/3X/f/c/fcf808c48a8d7835dbde6f89a5fb6f8b13a1b773.gif)

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

> **[Ingest pipelines | Elasticsearch Guide \[8.1\] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/8.1/ingest.html)**

---

_[View the full topic](https://discuss.elastic.co/t/metricbeat-sql-module-date-fields/297348)._