title: Converting UTC time in local time in PostgreSQL 8.3
body: <p>I run a Postgres 8.3 database where times seem to be stored in UTC without time zone.
  I am trying to display in local time but not with '+01' suffix :</p>
  
  <p>With select scheduled_start_ts I get :
  2014-01-20 05:01:35.663</p>
  
  <p>With select scheduled_start_ts at time zone 'MET' :
  2014-01-20 05:01:35.663+01</p>
  
  <p>I would like to get "2014-01-20 06:01:35.663" which is in local time.</p>
  
  <p>The database I am using cannot be modified and I am not allowed to modify how data are stored.</p>