title: Informix SQL: How to get the date part of a datetime field in a query?
body: <p>What is the best way to use a only the date part of a datetime field in a query?<br>
  I have a datetime field and want to group/count it by date.</p>