Need Postgres query result in given timezone

Question

I save all columns in UST. But I need to get all results in a particular timezone. I am using postgres.

I am looking for something like following

SELECT reported_time IN timezone 'Asia/Kolkata' FROM allusers;

I need result in 'Asia/Kolkata' timezone for exporting to a csv

Laurenz Albe · Accepted Answer · 2017-01-13 10:43:59Z

2

Provided that reported_time is of type timestamp with time zone as it should, the answer is

SELECT reported_time AT TIME ZONE 'Asia/Kolkata' FROM allusers;

answered Jan 13, 2017 at 10:43

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I need the result contain modified timezone info also. Currently, it returns without timezone info. Is there any way to achieve this

Are you looking for SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name = 'Asia/Kolkata'?