在Rails4中将数据库从sqlite3切换到mysql时出现strftime错误 [英] strftime error while switching my database from sqlite3 to mysql in Rails4
本文介绍了在Rails4中将数据库从sqlite3切换到mysql时出现strftime错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
最近我将数据库从sqlite3更改为mysql.运行项目时,我在使用此查询的文件之一中遇到此错误.
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.
date =今天的日期+ 1
date = Date.today + 1
@employees = Employee.where(状态=?AND strftime('%d/%m',date_of_birth)=?",活动",date.strftime('%d/%m')
@employees = Employee.where("status = ? AND strftime('%d/%m', date_of_birth) = ?", "Active" , date.strftime('%d/%m')
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: <% date = Date.today %>
212: <% @employees = Employee.where("status = ? AND strftime('%d/%m', date_of_birth) = ?", "Active" , date.strftime('%d/%m')) %>
213: <% if @employees.empty? %>
214:
215: <%else%>
216: <% @employees.each do |e| %>
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')
推荐答案
只需替换即可尝试
<% @employees = Employee.where("status = ? AND strftime('%d/%m', date_of_birth) = ?", "Active" , date.strftime('%d/%m')) %>
使用
<% @employees = Employee.where("status = ? AND DATE_FORMAT(date_of_birth,'%d/%m') = ?", "Active" , date.strftime('%d/%m')) %>
这篇关于在Rails4中将数据库从sqlite3切换到mysql时出现strftime错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文