title: .Net Core 3 Mysql Pomelo DateTime Incompatibility
body: <p>I want to get any data between two dates with .Net Core 3.1.3 Pomelo.EntityFrameworkCore.MySql v3.1.1</p>
  
  <p>When I try with C# datetime no data returns:</p>
  
  <pre><code>SELECT * FROM Availability where (StartDate &gt;= '26.03.2020 00:43:47' And StartDate &lt;= '26.03.2020 00:43:47') or (EndDate &lt;= '26.06.2020 00:43:47' And EndDate &lt;= '26.06.2020 00:43:47')
  </code></pre>
  
  <p>But I try Mysql datetime returns some data:</p>
  
  <pre><code>SELECT * FROM Availability where (StartDate &gt;= '2020-03-26 00:43:47' And StartDate &lt;= '2020-03-26 00:43:47') or (EndDate &lt;= '2020-06-26 00:43:47' And EndDate &lt;= '2020-06-26 00:43:47')
  </code></pre>
  
  <p>My C# codes:</p>
  
  <pre><code>prop =&gt; prop.Availabilities.Any(o =&gt; (o.StartDate &lt;= model.StartDate &amp;&amp; o.StartDate &gt;= model.StartDate) || (o.EndDate &lt;= model.EndDate &amp;&amp; o.EndDate &gt;= model.EndDate))
  </code></pre>
  
  <p>What i can do on .Net Core codes?</p>
  
  <p>Thanks.</p>