title: Not getting results even with long datetime formats in SQL
body: <p>I am trying to get some data that has datetime set, using the long format(ex: 2019-04-26 18:02:42).</p>
  
  <p>When I use the following query I expected to find the following entry:</p>
  
  <pre><code>SELECT ip, cam_id
  FROM test_table
  WHERE ( date_time &gt;= '2019-04-26 20:00:00' AND date_time &lt;'2019-04-26 20:59:59' );
  </code></pre>
  
  <p>Entry:</p>
  
  <pre><code> id  | ip | cam_id |      date_time
  -----+----+--------+---------------------
     1 | 13 |      2 | 2019-04-26 20:46:06
  </code></pre>
  
  <p>However I am not getting any results. What am I doing wrong?</p>
  
  <p>EDIT: Table schema</p>
  
  <pre><code> Kolon   |       Veri tipi        | S²ralama (collation) | Bo■ (null) olabilir |               Varsay²lan               | Saklama  | Stats hedefi | A²klama
  -----------+------------------------+----------------------+---------------------+----------------------------------------+----------+--------------+----------
   id        | integer                |                      | not null            | nextval('test_table_id_seq'::regclass) | plain    |              |
   ip        | integer                |                      |                     |                                        | plain    |              |
   cam_id    | integer                |                      |                     |                                        | plain    |              |
   date_time | character varying(255) |                      |                     |                                        | extended |              |
  ¦ndeksler:
      "test_table_pkey" PRIMARY KEY, btree (id)
  </code></pre>