DATE_FORMAT在其中条件的Codeigniter活动记录 [英] DATE_FORMAT in where condition of Codeigniter Active Record
本文介绍了DATE_FORMAT在其中条件的Codeigniter活动记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
select * from`table_name`其中DATE_FORMAT('table_name', %Y-%m)< YYYY-MM
我试过了,但是得到NULL作为答案。
$ this-> db-> select_sum('column_name') - > from('table_name') - >其中(DATE_FORMAT('column_name','%Y-%m')<,YYYY-MM) - > get
Thnx有任何帮助吗?
解决方案
使用无引号 column_name
如 DATE_FORMAT(column_name,'%Y-%m')
$ this-> db-> select_sum('column_name')
- > from 'table_name')
- > where(DATE_FORMAT(column_name,'%Y-%m')<,YYYY-MM)
- > get
I want the Codeigniter equivalent of the sql below:
select * from `table_name` where DATE_FORMAT('table_name', "%Y-%m") < "YYYY-MM"
I have tried it but get NULL as the answer.Here is how i did it
$this->db->select_sum('column_name')->from('table_name')->where("DATE_FORMAT('column_name','%Y-%m') <","YYYY-MM")->get();
Thnx for any help?
解决方案
Use without quotes column_name
like DATE_FORMAT(column_name,'%Y-%m')
$this->db->select_sum('column_name')
->from('table_name')
->where("DATE_FORMAT(column_name,'%Y-%m') <","YYYY-MM")
->get();
这篇关于DATE_FORMAT在其中条件的Codeigniter活动记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文