# Ingestion pipeline milliseconds

**URL:** https://discuss.elastic.co/t/ingestion-pipeline-milliseconds/275967
**Category:** Kibana
**Tags:** ingest-pipeline
**Created:** [June 15, 2021, 9:13am UTC](https://discuss.elastic.co/t/ingestion-pipeline-milliseconds/275967 "2021-06-15T09:13:22Z")
**Posts on this page:** 1
**Showing post:** 11

<div class="post-metadata">

### Author: ![accateo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/accateo/32/85332_2.png) [@accateo](https://discuss.elastic.co/u/accateo)
#### Post date: [June 16, 2021, 10:51am UTC](https://discuss.elastic.co/t/ingestion-pipeline-milliseconds/275967/11 "2021-06-16T10:51:26Z")

</div>

Sorry but yes, I need the current timestamp in UNIX format, every time I receive a document...

I dont know how to explain in another way.

The problem I have is this:

> [@Kibana essql query date diff](https://discuss.elastic.co/t/kibana-essql-query-date-diff/271483/15):
>
> Hi Felix, I already tried the sort function....nothing change. Current situation: with expression: filters group="group3" ungrouped=true | essql query="SELECT DAY(date) as dd, MIN(date) as realDate, DATE\_DIFF('hours',MIN(date),MAX(date)) as diff FROM \"application\_data\_bridgenuzoo\" GROUP BY DAY(date)" | mapColumn name="formatted\_date" expression={getCell "realDate" | formatdate format="DD/MM/YY"} | pointseries x="formatted\_date" y="diff" | plot defaultStyle={seri…

but no one has helped me anymore...

---

_[View the full topic](https://discuss.elastic.co/t/ingestion-pipeline-milliseconds/275967)._