`showdate` is a datetime field - the following sql returns all rows, not only the ones with dates later than 2016-08-31. 

```
SELECT * FROM  shows WHERE  showdate >  '2016-08-31'

```

I did a workaround by creating a unixdate field, and making the query like this:

```
SELECT * FROM  shows WHERE  udate >1472626800

```

However, from what I read, the former should work, and I am curious as to why it doesn't.