title: Getting invalid interval error in oracle while using DbFunctions Add Minutes Method in entityframework
body: <p>I am trying to add minutes to my date column and then use a where clause to compare date.</p>
  
  <pre><code>DateTimeOffset offset;
  var dto = DateTimeOffset.TryParse(searchTerm, out offset);
  var offSettMintutes = (int)offset.Offset.TotalMinutes;
  if(!dto)
  {
  offSettMintutes = 0;
  }
  var filteredQuery = queryForRequests.Where(item =&gt; DbFunctions.TruncateTime(DbFunctions.AddMinutes(item.SUBMIT_DATE, offSettMintutes)) == searchTermDate);
  </code></pre>
  
  <p>It is throwing error saying </p>
  
  <blockquote>
    <p>{"ORA-01867: the interval is invalid"}</p>
  </blockquote>