Select only records around a certain time
<p>In my database, there's a record every single minute. I want to only select every record that's created around every fifteen minutes.</p>

<p>The following code shows how I currently execute this query, but with the statement: <code>v.CreateTime &gt; v.CreateTime &lt; endDate)</code>, I'm only declaring between what dates I would like to get the data.</p>

<p>I want the data with times of <code>:15, :30, :45, :00</code>. Also the data in not entered in precisely at those times. For example <code>12:15:23</code> is possible, but <code>12:14.43</code> is also possible.</p>

<pre><code>vafDataList = service.LoadVesselRecord&lt;VafData&gt;(v =&gt; 
      v.TypeNo == RecordObjectTypes.VafData &amp;&amp; 
      v.Vessel_No == vesselNo &amp;&amp; 
      v.CreateTime &gt; startDate &amp;&amp; 
      v.CreateTime &lt; endDate)
  .OrderBy(t =&gt; t.CreateTime)
  .ToList();
</code></pre>

<p>How can I select only the records around the quarters of an hour, and not all records?</p>