How do I show the local time zone along with timestamp instead of UTC

I want to show local time zone like IST, CST with date time .Now it is showing only UTC. In postgresql it is showing as IST but while execute the same query in appsmith it is showing as UTC.

@Ginjo can you share the query you are using?

Hi this is my query in postgresql

SELECT to_char( A.last_updated_date ,‘dd-mm-YYYY HH12:MI:SS AM TZ’) ) as last_updated_date
FROM customer_details A order by A.last_updated_date desc

@Ginjo Apologies for the late reply. I lost track of this one. Have you tried using at time zone For eg: something like SELECT "createdAt" at time zone 'UTC' at time zone 'Asia/Calcutta' FROM users;

@dancia Tried the above syntax but time showing incorrectly for this. Also in appsmith application it showing UTC again not local time zone.

For this query ,

SELECT to_char( A.last_updated_date ,‘dd-mm-YYYY HH12:MI:SS AM TZ’) ) as last_updated_date
FROM customer_details A order by A.last_updated_date desc

the result is as : 20-01-2022 02:26:41 PM IST in postgresql

but the same date is showing in application as : 20-01-2022 08:56:41 AM UTC.

@Ginjo Hey sorry you are still facing this issue. I checked with the team and they suggested using the moment() function like this moment().tz("America/Los_Angeles").format();

@dancia ok I will try it