title: postgresql: how to convert UTC timestamp to Sydney time
body: <p>I have a PostgreSQL DB with many tables that store timestamps in Sydney/Australia local time. In addition, I have one table which stores timestamps in UTC. This cannot be changed.</p>
  
  <p>My question is - 
  What SQL manipulation do I need to use in order to get the UTC timestamps in local Sydney/Australia time?</p>
  
  <p>I am conscious of the fact that Sydney has periods of daylight savings, and I'm not sure how to write my SQL so that the conversion will always be correct - no matter if the timestamp was taken during daylight saving or not.</p>
  
  <p>Please advise.</p>
  
  <p>Thanks,
  Amit </p>