title: strftime error while switching my database from sqlite3 to mysql in Rails4
body: <p>Recently i changed my database from sqlite3 to mysql.When i ran my project i am getting this error in one of the file which is using this query.</p>
  
  <p>date = Date.today + 1</p>
  
  <p>@employees = Employee.where("status = ? AND strftime('%d/%m', date_of_birth) = ?", "Active" , date.strftime('%d/%m')</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>ActionView::Template::Error (Mysql2::Error: FUNCTION hrms_development.strftime does not exist: SELECT COUNT(*) FROM `employees` WHERE (status = 'Active' AND strftime('%d/%m', date_of_birth) = '28/03')):
      210:             
      211:               &lt;% date = Date.today %&gt;
      212:              &lt;% @employees = Employee.where("status = ? AND strftime('%d/%m', date_of_birth) = ?", "Active" , date.strftime('%d/%m')) %&gt;
      213:             &lt;% if @employees.empty? %&gt;
      214:              
      215:             &lt;%else%&gt;
      216:               &lt;% @employees.each do |e| %&gt;
    app/views/home/_group_admin.html.erb:213:in `_app_views_home__group_admin_html_erb___2522183600721478262_91627100'
    app/views/home/index.html.erb:17:in `_app_views_home_index_html_erb__2772204906267359422_86967120'
  
  
  
  ActionView::Template::Error: Mysql2::Error: FUNCTION hrms_development.strftime does not exist: SELECT COUNT(*) FROM `employees` WHERE (status = 'Active' AND strftime('%d/%m', date_of_birth) = '28/03')</code></pre>
  </div>
  </div>
  </p>