how to substring field in YII

kuncolaksmono · February 12, 2016, 3:14am

I Have application can running in 3 databases with Yii framework.

Example table with field (id, selectdate)

1 2015-10-04 10:10:24

2 2015-10-04 21:10:24

3 2015-09-20 11:10:24

I want to query with where = 2015-10-04. How to query ??

SELECT id, SUBSTRING(selectdate, 0, 11) AS scandate FROM scan WHERE scandate = ‘2015-10-04’ ==> can not running well

phtamas · February 12, 2016, 4:20am

Try to compare dates as dates (rather than strings). It’s usually faster, more intuitive and more reliable.


WHERE selectdate >= '2015-10-04' AND selectdate < '2015-10-05'

Or, for MySQL:


WHERE DATE(selectdate) = '2015-10-04'

oligalma · February 13, 2016, 1:15am

You can also use the BETWEEN keyword:


WHERE selectdate BETWEEN '2015-10-04' AND '2015-10-05'

kuncolaksmono · March 10, 2016, 10:53am

Thank you

kuncolaksmono · March 10, 2016, 10:54am

phtamas:

Try to compare dates as dates (rather than strings). It’s usually faster, more intuitive and more reliable.
WHERE selectdate >= '2015-10-04' AND selectdate < '2015-10-05'
Or, for MySQL:
WHERE DATE(selectdate) = '2015-10-04'

Thank you