I have a connection to snowflake set up via toad data point. The timezone parameter in snowflake is set to America/New_York on user/session/account level. However, TIMESTAMP_LTZ fields are being defaulted in the toad data point to whatever timezone parameter toad is setting on its end. Where can I find the options to change this?
Example - these return different values.
to_char gives us the correct timestamp based on snowflake America/New_York timezone set on the user and session level. Not including to_char returns the timestamp in my local timezone. I do not want everything converted to my local timezone.