Don't use the database. That will give the database timezone. Use the Perspective Session property timeZoneId.
https://docs.inductiveautomation.com/display/DOC81/Session+Properties
Application ideas here:
However, note that most Perspective Components will handle timezone conversions (including locale formatting) for you if you simply leave standard java datetime objects in your data (java.util.Date is built on milliseconds UTC), or provide long integer milliseconds-UTC in your data. In some components, like the table, you might have to request datetime formatting to engage this handling.