Setting timezone for Postgresql resource

Queries and Resources
1

I'm trying to set timezone for my query.

When I just use

SET timezone = 'America/New_York';

It goes without an error.

But if I use

SET timezone = 'America/New_York';
SELECT ...

It fails with "Syntax error near SET".

Is that some Retool constraint?

2

Hey @sykac,

Not sure if you can change run-time configuration parameters for queries, try

SELECT
  your_time::timestamp AT TIME ZONE 'America/New_York'
...