title: ODATA DATE QUERY
body: <p>I need to return records that have a date of 4/4/2013 (for example).
  The date field in the ODATA service returns as {DATE: "2013-04-04T17:39:33.663"}</p>
  
  <p>How is the query supposed to look like?</p>
  
  <p>So far, I have seen three options to do this, but none of them are straight forward.</p>
  
  <p>Option one:  datetime'2013-04-04T12:00':  this requires specification of time</p>
  
  <p>Option two:  month(DATE) eq 04  day(DATE) eq 04 year(DATE) eq 2013: this is cumbersome </p>
  
  <p>Option three: using option one with 'ge' and 'le' to get records between 2 dates: this is also crap.</p>
  
  <p>This should be very simple as it is in T-SQL.  </p>