# Formatting @timestamp in Canvas

**URL:** https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084
**Category:** Kibana
**Tags:** canvas
**Created:** [October 10, 2019, 6:06pm UTC](https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084 "2019-10-10T18:06:04Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![bkleynbok](https://avatars.discourse-cdn.com/v4/letter/b/d2c977/32.png) [@bkleynbok](https://discuss.elastic.co/u/bkleynbok)
#### Post date: [October 10, 2019, 6:06pm UTC](https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084/1 "2019-10-10T18:06:04Z")

</div>

In ELK Stack 7.3 using Kibana and Canvas.  
So the issue I discovered in formatting @timestamp into a date time.  
This is the original message :

```auto
{"@timestamp":"2019-10-08T16:35:14.455Z","hostname":"MYHost2","ip":"2.2.2.2","vm":"VM Desc 2","status":"UP","latency":"2ms"}

```

This is my Elastic Search output  
{  
"\_index": "boris-topic",  
"\_type": "\_doc",  
"\_id": "3wqosW0BN-pLbXvgd41G",  
"\_version": 1,  
"\_score": null,  
"\_source": {  
"vm": "VM Desc 2",  
"@timestamp": "2019-10-08T16:35:14.455Z",  
"ip": "2.2.2.2",  
"status": "UP",  
"hostname": "MYHost2",  
"@version": "1",  
"latency": "2ms"  
},  
"fields": {  
"@timestamp": [  
"2019-10-08T16:35:14.455Z"  
]  
},  
"sort": [  
1570552514455  
]  
}

This is from Canvas:

filters  
| essql  
query="SELECT "@timestamp" as time, hostname FROM "boris-topic\*"  
where hostname is not null"  
| mapColumn time fn={ getCell time | formatdate format="dddd, MMMM Do YYYY, hh:mm:ss" }  
| table paginate=true showHeader=true  
| render

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/0/70943d643159d5cdaee4b557f707b0b0d29eca8b.png)

The original field had "@timestamp": [  
"2019-10-08T16:35:14.455Z"

This is in Kibana:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/5/152960a9b611434a17993cd7a50833a3eeb854ef.png)  
In Kibana the @timestamp is Oct 8, 2019 @ 12:35:14.455

The datetime on the canvas is wrong  
Please help!

---

<div class="post-metadata">

### Author: ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)
#### Post date: [October 10, 2019, 8:06pm UTC](https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084/2 "2019-10-10T20:06:22Z")

</div>

I believe you're running into a timezone issue, which is something being tracked here: [https://github.com/elastic/kibana/issues/33959](https://github.com/elastic/kibana/issues/33959)

---

<div class="post-metadata">

### Author: ![bkleynbok](https://avatars.discourse-cdn.com/v4/letter/b/d2c977/32.png) [@bkleynbok](https://discuss.elastic.co/u/bkleynbok)
#### Post date: [October 10, 2019, 8:17pm UTC](https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084/3 "2019-10-10T20:17:42Z")

</div>

I understand that @timestamp is in UTC format. When I set the dateFormat:tz as UTC I would see same format in both Discover Table and JSON.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/c/ccd4f458b4604dd333928f1b7098433b685d8062.png)

In Canvas I am not able to change format to my timezone. I tried many ways however I can only see the UTC format.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/5/45d5e92f971643223cc76088d14c0c473f52445f.png)

---

<div class="post-metadata">

### Author: ![bkleynbok](https://avatars.discourse-cdn.com/v4/letter/b/d2c977/32.png) [@bkleynbok](https://discuss.elastic.co/u/bkleynbok)
#### Post date: [October 11, 2019, 6:36pm UTC](https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084/4 "2019-10-11T18:36:14Z")

</div>

Is there a workaround for this time format issue?

---

<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: [November 8, 2019, 6:36pm UTC](https://discuss.elastic.co/t/formatting-timestamp-in-canvas/203084/5 "2019-11-08T18:36:17Z")

</div>

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