title: Unix time Format not working in Laravel where clause
body: <p>I have a query in Laravel query builder like this. And I want to get data from a particular year </p>
  
  <pre><code>$query = blogs::where(array('blogs.status' =&gt; '1','blog_categories.status' =&gt; '1','categories.status' =&gt; '1','blogs.published' =&gt; '1'));
  
  if (isset($year) and $year != NULL)$query-&gt;where("FROM_UNIXTIME(blogs.pubdate, '%Y')", '=', $year); 
      $result= $query-&gt;leftJoin('blog_categories', 'blog_categories.blogid', '=', 'blogs.blogid')-&gt;leftJoin('categories', 'blog_categories.catid', '=', 'categories.catid')-&gt;orderBy('blogs.publisheddate', 'desc')-&gt;count();
  </code></pre>
  
  <p>I got an error  'FROM_UNIXTIME' command. Here my 'blogs.pubdate' is in timestamp format (1456313400).Any idea?</p>
  
  <p>Thanks for helping.</p>