title: GETDATE() throwing exception
body: <p>I am creating a simple application where i am using <strong>MSAccess</strong> as database.
  When i am trying to retrieve the data using below query - i am getting exception <strong>undefined function GETDATE()</strong></p>
  
  <pre><code>select *
  from tempdata
  where dateissue  between DATEADD(MM, DATEDIFF(MM, 0, GETDATE()) - 0 , 0) 
  and  DATEADD(MM,         DATEDIFF(MM, 0, GETDATE()) + 1, - 1 )
  </code></pre>
  
  <p>can't we use the sql inbuilt methods inside c# code ?? if so how do i solve this problem</p>