You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.