# Perspective table time **URL:** \ **Category:** Ignition\ **Tags:** perspective, vision\ **Created:** [March 29, 2023, 8:36am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757 "2023-03-29T08:36:18Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Post date:** [March 29, 2023, 8:36am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/1 "2023-03-29T08:36:18Z")
Ignition 8.1.25 I have some data in an SQL table as shown below. Note that the column formats are date, time(3), time(3)... This data will be used to schedule operation of a machine. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/c/ec0bd422879fde120f172ab84cb2cf588e031dde.png) When I read the data back via an SQL query in a script, it shows as expected. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/6/863b8166c1c514badbae8b94872fedd92c4a713d.png) However, when I send this data to a table in Perspective, the columns for "dawn" and "sunrise" show wierd numbers. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/b/8b7abcab83c4cc27dc700b9cd3d3ec866ff1bb51.png) If I use a table in Vision, the correct times are shown for "dawn" and "sunrise" ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/0/60bc7081b41eac94667839602da54ed09b20ac4b.png) My Perspective table is set up as shown below. All other columns are set up the same as "dawn" but with appropriate names in "field". ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/1/d197dfbe129449347050af3b521627db18e62d4c.png) The other columns appear to be set up identically and they work fine. I'm stuck on this. Can someone point out where I am going wrong? Why these 2 columns are 30 mins behind the actual data in SQL and why does it work in Vision but not in Perspective? Cheers ---
**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:** [March 29, 2023, 8:45am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/2 "2023-03-29T08:45:58Z")
Q1: What time zone are you in? Q2: What happens if you set `columns.1.render : date` rather than `auto`? Q3: What value is shown in `props.data` for that column? ---
**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Post date:** [March 29, 2023, 8:56am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/3 "2023-03-29T08:56:31Z")
Thanks for the speedy reply. I'm on NZT (UTC + 12). I had a play with render. This seems to have no effect. Good call on props.data. This shows the correct time ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/3/23532c1939a33ebfb2ef936e3a957c98af8a3525.png) ---
**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Post date:** [March 29, 2023, 9:03am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/4 "2023-03-29T09:03:14Z")
For a test, I created a new SQL table with one row. This time I used the format "datetime" for the columns in question. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/0/f06589f32690c762c7472a9243f6f21db534430e.png) This seems to circumvent the issue but it is not a viable solution without a lot of work on the data sources. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/d/5dee3e2dc55c856129307dee87f694531d40800c.png) ---
**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:** [March 29, 2023, 9:21am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/5 "2023-03-29T09:21:07Z")
Yup. Bad initial setup will bite you in the end. What are the times' datatype? Strings? ---
**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Post date:** [March 29, 2023, 10:46am UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/6 "2023-03-29T10:46:44Z")
The datatype is "time". The data comes from a nasty Excel spreadsheet and then to sql. I might look at changing the parsing code for this. It seems like ignition does not play nicely with this datatype. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/344ff7f9cdba363c4a77830175a1ea3315d3306f.png) ---
**Author:** ![eichler-eng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/eichler-eng/32/21259_2.png) [@eichler-eng](https://forum.inductiveautomation.com/u/eichler-eng)\ **Post date:** [April 2, 2023, 10:02pm UTC](https://forum.inductiveautomation.com/t/perspective-table-time/71757/7 "2023-04-02T22:02:45Z")
I have changed our Excel parsing code so that we can use "datetime" format instead of "time(3)" in the SQL table. The issue with the perspective table is now resolved. It would be good to hear from the Ignition team about the issue with using SQL "time" format in a Perspective table. Thanks @Transistor for your input.