Thanks for the reply.

I may not have explained myself very well but I have made a bit of progress, when I round the date field I am seeing the results I expect.

SELECT COUNT(*) FROM table WHERE ROUND(myDATEcolumn) = '17-FEB-16'

So myDATEcolumn has a time in it, that I can't see.

Is there some kind of set option, or system option that hides the time from a date field?

How can I see the time in this field.

If I just do SELECT myDATEcolumn .... it returns in this format '17-Feb-16'