title: Getting wrong date (wrong offset) from PostgresDB when querying with doctrine
body: <p>I am totally confused about tz (timezones) and datetypes in Symfony and Doctrine.
  We are using Symfony 5 and PostgresSQL for the database. In the database we’re using timestamptz for all dates and in the entities we are explizit defining all dates as datetimetz.</p>
  <p>@ORM\Column(type=&quot;<strong>datetimetz</strong>&quot;, nullable=true)</p>
  <p>When we create a query with the doctrine querybuilder (createQuery) we’re always losing our saved offset (timezone) from the database. Example: in the database we have:</p>
  <pre><code>Date: 2021-05-10 00:06:35
  Offset: 2.0
  </code></pre>
  <p>As a result from the query we get:</p>
  <pre><code>[date] =&gt; 2021-05-09 22:06:35.000000
  [timezone_type] =&gt; 1
  [timezone] =&gt; +00:00
  </code></pre>
  <p>Btw.: we got the same result when using the repository (getRepository) instead of querying directly.</p>
  <p>My question: where did my date get converted and why? Will it be at the database site or on the php level?</p>
  <p>Btw. 2: the database default offset is set to <strong>Europe/Berlin</strong> and the php side as well with <strong>date_default_timezone_set</strong>.</p>