How to use SUBSTRING in query
How to use SUBSTRING in query
misteam
Posts: 48Questions: 17Answers: 0
How to use SUBSTRING something like this:
Thank you in advance!
This discussion has been closed.
Answers
Hi Sir @allan, Thanks
I believe your
0
should actually be a1
. Testing it locally like that allows it to work.See also the MySQL documentation which states:
Allan
We got it sir @allan, this one is working:
$q->and_where( 'SUBSTR(date_and_time_received,1,10)',$GLOBALS["date_now"], '=' );