title: Room : incorrect result of a query with a date condition
body: <p>This query is retrieving all the records whatever the date for the pet :</p>
  
  <pre><code>@Query("SELECT * FROM Fooding WHERE pet_Id = :petId AND date(fooding_date) = date(current_timestamp)")
  Flowable&lt;List&lt;Fooding&gt;&gt; getDailyFoodingsForPet (Long petId);
  </code></pre>
  
  <p>Converters :</p>
  
  <pre><code>private static final DateTimeFormatter dtf = DateTimeFormatter.ISO_OFFSET_DATE_TIME;
  
  @androidx.room.TypeConverter
  public static OffsetDateTime toOffsetDateTime(String value) {
     return value == null ? null : OffsetDateTime.parse(value,dtf);
  }
  
  @androidx.room.TypeConverter
  public static String fromOffsetDateTime(OffsetDateTime value) {
     return value == null ? null : value.format(dtf);
  }
  </code></pre>
  
  <p>Entity :</p>
  
  <pre><code>public class Fooding implements Parcelable {
      @NonNull
      @PrimaryKey(autoGenerate = true)
      private Long foodingId;
      @NonNull
      @ColumnInfo(name = "user_Id")
      private Long userId;
      @NonNull
      @ColumnInfo(name = "pet_Id")
      private Long petId;
      @TypeConverters(DataTypeConverter.class)
      @ColumnInfo(name = "fooding_date")
      private OffsetDateTime foodingDate;
      private Integer quantity;
  </code></pre>
  
  <p>Does anyone have any idea of ​​the problem ?</p>
  
  <hr>
  
  <p>Edit : this query have the same result :</p>
  
  <pre><code>@Query("SELECT * FROM Fooding WHERE pet_Id = :petId AND date(fooding_date) = date('now')")
  Flowable&lt;List&lt;Fooding&gt;&gt; getDailyFoodingsForPet (Long petId);
  </code></pre>