Understanding Timestamps in Postgres and PHP: Converting UTC to Local Time with Parameterized Queries, Built-in Functions, and Best Practices for Accurate Conversions.