title: How to convert date time stamp in query itself
body: <p>Is there any way to convert mysql database date field to timestamp like strtotime in query itself?</p>
  
  <p>my code:</p>
  
  <pre><code>  $this-&gt;db-&gt;where('effectdate &gt;= ',$start_date);
    $this-&gt;db-&gt;where('effectdate &lt;= ',$end_date);
    $query = $this-&gt;db-&gt;get();
  </code></pre>
  
  <p>$start_date and $end_date are timestamp values but database value is normal date.Is these anyway to convert date to timestamp ?
  Please help.</p>