# How to display @timestamp as SGT rather than UTC in Canvas **URL:** \ **Category:** Kibana\ **Created:** [June 27, 2019, 9:30am UTC](https://discuss.elastic.co/t/how-to-display-timestamp-as-sgt-rather-than-utc-in-canvas/187796 "2019-06-27T09:30:39Z")\ **Posts on this page:** 3\ **Page:** 1
**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:** [June 27, 2019, 9:30am UTC](https://discuss.elastic.co/t/how-to-display-timestamp-as-sgt-rather-than-utc-in-canvas/187796/1 "2019-06-27T09:30:39Z")
Hello, I am playing around in Canvas and was trying to write an ESSQL query to show CPU usage. However, the timestamp shown is always in UTC time and i am unable to cast it to local time (SGT). `SELECT "@timestamp" as Time, system.cpu.user.pct*100 as "CPU USAGE" FROM "metricbeat-*" order by "@timestamp" DESC` This is my current query and how can i cast the UTC timestamp to + 8 hours? ---
**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:** [June 27, 2019, 9:42am UTC](https://discuss.elastic.co/t/how-to-display-timestamp-as-sgt-rather-than-utc-in-canvas/187796/2 "2019-06-27T09:42:00Z")
I manually added 8 hours to timestamp to display the local time but i am not sure if this is proper or not... `SELECT CAST("@timestamp" AS DATETIME) + INTERVAL 8 HOURS AS result, system.cpu.user.pct*100 as "CPU USAGE" FROM "metricbeat-*" order by "@timestamp" DESC` Is there a proper method to do this? or my way is fine? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 25, 2019, 9:42am UTC](https://discuss.elastic.co/t/how-to-display-timestamp-as-sgt-rather-than-utc-in-canvas/187796/3 "2019-07-25T09:42:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.