Postgres - Display Localized Hours

I’m writing a query to display in a Pie Chart to show the most popular hours that an event has occurred. This works great, except that all of the hours display as UTC (which is how they’re stored in my Postgres DB). I’d like them to display in the timezone of the user. Is this possible?

SELECT
  $__time(start_time),
  to_char(start_time, 'HH') || to_char(start_time, 'am') || '-' || to_char(start_time + interval '1h', 'HH') || to_char(start_time + interval '1h', 'am') as outcome,
  COUNT(*) as "measurement"
FROM sessions
WHERE 
  $__timeFilter(start_time)
group by start_time, outcome
ORDER BY outcome DESC