title: First day of current year
body: <p>I have the below query in a postgresql database</p>
  
  <pre><code>SELECT * 
  FROM accounts 
  where insertdate BETWEEN '2012-01-01' AND CURRENT_TIMESTAMP
  </code></pre>
  
  <p>So how can I replace the <code>'2012-01-01'</code> asking for the first day of the current year</p>
  
  <p>There is one more issue. When I m having a new record in the account table the same moment is running the above select so it doesnt bring me the record I have just made.Is it reasonable?
  What is the best way to overtake it?</p>