# Perspective table component applying time zone offsets to dates **URL:** \ **Category:** Ignition\ **Created:** [December 22, 2021, 2:04pm UTC](https://forum.inductiveautomation.com/t/perspective-table-component-applying-time-zone-offsets-to-dates/54393 "2021-12-22T14:04:11Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![ShaneH](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Post date:** [December 22, 2021, 2:04pm UTC](https://forum.inductiveautomation.com/t/perspective-table-component-applying-time-zone-offsets-to-dates/54393/1 "2021-12-22T14:04:11Z")
Using Perspective 8.1.11 I have a dataset with date/time columns containing UTC date/time values. When I display them in a Perspective table component, if I set ‘render=auto’, it will apply a local time offset and render them as local times. If I set ‘render=date’, it does _NOT_ apply the local time offset, and instead displays them as their original UTC times. I’m fine with this, I just want to know if this is the intended way the component is meant to work, or if it’s a bug that might be fixed at later time, or if I’m possibly doing something wrong. I couldn’t really find any clarification in the documentation. Thanks. -Shane ---
**Author:** ![ShaneH](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Post date:** [December 23, 2021, 2:45pm UTC](https://forum.inductiveautomation.com/t/perspective-table-component-applying-time-zone-offsets-to-dates/54393/2 "2021-12-23T14:45:02Z")
Anyone want to weigh in? Is this the intended way for the table component to work? ---
**Author:** ![andrews](https://avatars.discourse-cdn.com/v4/letter/a/898d66/32.png) [@andrews](https://forum.inductiveautomation.com/u/andrews)\ **Post date:** [December 23, 2021, 3:20pm UTC](https://forum.inductiveautomation.com/t/perspective-table-component-applying-time-zone-offsets-to-dates/54393/3 "2021-12-23T15:20:19Z")
I’m curious as well. I’m not super familiar with Perspective. My guess would be its normal. render=date just shows it as that /o any extra work. And the render=auto must do conversion. But this is something they could probably correct in a future version. but again this is just to add to the thread, take everything with a grain of salt. Hopefully a more experienced user or someone from IA can add/clarify ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [December 23, 2021, 10:22pm UTC](https://forum.inductiveautomation.com/t/perspective-table-component-applying-time-zone-offsets-to-dates/54393/4 "2021-12-23T22:22:26Z")
See also [Perspective date picker daylight savings?](https://forum.inductiveautomation.com/t/perspective-date-picker-daylight-savings/53595). The date picker also has some daylight saving quirks. ---
**Author:** ![UMESHCHANDRA\_ADAMANK](https://avatars.discourse-cdn.com/v4/letter/u/3ab097/32.png) [@UMESHCHANDRA\_ADAMANK](https://forum.inductiveautomation.com/u/UMESHCHANDRA_ADAMANK)\ **Post date:** [January 18, 2022, 5:04pm UTC](https://forum.inductiveautomation.com/t/perspective-table-component-applying-time-zone-offsets-to-dates/54393/5 "2022-01-18T17:04:33Z")
@ShaneH Yes that is what the intended way the table component is meant to work and not a bug. Because while using table component in perspective 8.1.0 I am facing serious issue as this feature is not there and its a bug here in this version. Setting up render auto is adding offset & showing local time. Setting up render to Date is still adding offset & showing local time instead of showing UTC time. let me explain more with the example. my dB & Ignition Gateway both set to UTC while I am launching client from IST(+5.5) I am getting this offset With respect to the local time zone. This may vary and will show incorrect data if you access view from different zones. Thanks Umeshchandra Adamanke. ![Untitled](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/7/57383197c9a875cf2e907959f441ee40ab04a83b.png)