# Using Canvas with essql timestamp of YYYY-MM-DDTHH:MM:SS

**URL:** <https://discuss.elastic.co/t/using-canvas-with-essql-timestamp-of-yyyy-mm-ddthhss/189006>\
**Category:** Kibana\
**Created:** [July 5, 2019, 5:33am UTC](https://discuss.elastic.co/t/using-canvas-with-essql-timestamp-of-yyyy-mm-ddthhss/189006 "2019-07-05T05:33:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![TsuWeiQuan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsuweiquan/32/46252_2.png) [@TsuWeiQuan](https://discuss.elastic.co/u/TsuWeiQuan)\
**Post date:** [July 5, 2019, 5:33am UTC](https://discuss.elastic.co/t/using-canvas-with-essql-timestamp-of-yyyy-mm-ddthhss/189006/1 "2019-07-05T05:33:39Z")

</div>

Hello,

I am following [this guide](https://discuss.elastic.co/t/canvas-how-to-make-stacked-area-chart/180399/4) to learn how to plot in canvas and i realized that the time used in canvas is in this format: `2019-05-01 00:00:00`.  
However, when I queried the timestamp from elasticsearch, it is in this format `2019-07-02T18:29:21`

Can i use canvas in `2019-07-02T18:29:21` format or i have to convert it in canvas code expression?  
If yes, how can i convert it?

This is my attempt and it does not work.

```
filters
| essql 
  query="SELECT CAST(\"@timestamp\" AS DATETIME) + INTERVAL 8 HOURS AS time, system.memory.actual.used.bytes AS Used, system.memory.actual.free AS Free FROM \"metricbeat-*\" WHERE host.hostname='NUSSERVER' AND system.memory.actual.used.bytes IS NOT NULL AND system.memory.used.bytes IS NOT NULL ORDER BY \"@timestamp\" DESC "
| mapColumn "time" expression={getCell "\"@timestamp\"" | formatdate format="YYYY-MM-DD HH:mm:ss"}
| pointseries x="time" y="mean(Free)" color="mean(Used)"
| plot defaultStyle={seriesStyle lines="1" fill=1 stack="1"} 
  palette={palette "#882E72" "#B178A6" "#D6C1DE" "#1965B0" "#5289C7" "#7BAFDE" "#4EB265" "#90C987" "#CAE0AB" "#F7EE55" "#F6C141" "#F1932D" "#E8601C" "#DC050C" gradient=false}
| render

```

Thank you.

---

<div class="post-metadata">

**Author:** ![TsuWeiQuan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsuweiquan/32/46252_2.png) [@TsuWeiQuan](https://discuss.elastic.co/u/TsuWeiQuan)\
**Post date:** [July 5, 2019, 6:59am UTC](https://discuss.elastic.co/t/using-canvas-with-essql-timestamp-of-yyyy-mm-ddthhss/189006/2 "2019-07-05T06:59:03Z")

</div>

Found the solution.  
Apparently it was quite simple.

`| mapColumn time fn={ date | formatdate "YYYY-MM-DD hh:mm:ss" }`

Read from [here](https://www.elastic.co/blog/kibana-canvas-data-table-and-debug-elements)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [August 2, 2019, 7:14am UTC](https://discuss.elastic.co/t/using-canvas-with-essql-timestamp-of-yyyy-mm-ddthhss/189006/3 "2019-08-02T07:14:39Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.