SQL logs timestamps in two formats:
timestamp refers to timestamp without timezone, whereas
timestamptz refers to timestamp with timezone. Benchling warehouse stores
datetime data in UTC timezone.
Therefore, if you’d like to show timezones in your query, cast your timestamp value to
timestamptz before converting to your desired timezone as shown below:
timezone('US/Pacific', inoculation.datetime::timestamptz) as "Inoculation Time"
FROM seagen.cc_inoculation_volumes$raw as inoculation
List of available timezones: https://www.postgresql.org/docs/7.2/timezones.html
More details on using timezones: https://phili.pe/posts/timestamps-and-time-zones-in-postgresql/