Data rendered in UTC instead of Australia/Sydney time.

Hi All, I am getting data from supabase in Australia/Sydney time (which i what I need) but Plasmic is rendering it as UTC, anyone know how to fix that? Is there a dat setting for my workspace as it seems to be converting it back.

Hi, I believe the issue is that you are using a timestamp column instead of a timestamp with time zone column in postgres. In general you should always use the latter instead of the former, because if you don’t specify a time zone, postgres will just assume the local time zone of the server it’s running on, which in the case of SB is UTC