postgreSQL sorting with timestamps
<p>I have the following SQL statement:</p>

<pre><code>SELECT * FROM schema."table"
  WHERE "TimeStamp"::timestamp &gt;= '2016-03-09 03:00:05'
  ORDER BY "TimeStamp"::date asc
  LIMIT 15
</code></pre>

<p>What do I expect it to do? Giving out 15 rows of the table, where the timestamp is the same and bigger than that date, in ascending order. But postgres sends the rows in the wrong order. The first item is on the last position. <a href="https://i.stack.imgur.com/1iWki.png" rel="noreferrer"><img src="https://i.stack.imgur.com/1iWki.png" alt="SQL Editor with result"></a>
So has anyone an idea why the result is this strange?</p>