Hi! I just started to learn Perspective so I took a SQL query I used before in another Ignition page, converted it to a named query and tested it in a table. It works but how do i change the columns header? And how do I change the format so I get the date in format ‘2019-10-21 12:00:00’?

Perspective table questions

jonathan.taylor October 21, 2019, 11:58am 2

This post will help you a lot:

Also, you could change the column header without doing anything in the table by adjusting the named query:

SELECT tableColumn AS newHeader FROM table