Using STR_to_DATE in PHP SQL Query

712 views Asked by At

I need a way of changing the format the date format from datetime to just the date in an SQL query, I have tried:

$sql="SELECT created_by FROM meetings WHERE STR_TO_DATE('date_start', 'Y-m-d')='$CorrectDate'";

but to no avail.

date_start is the field in the SQL table.

Any help welcome!!!

1

There are 1 answers

2
Quassnoi On
SELECT  created_by
FROM    meetings
WHERE   date_start >= $correctDate
        AND date_start < $correctDate + INTERVAL 1 DAY

Unlike any solution which involves a function or an expression over date_start, this one is sargable, i. e. able to use an index on date_start efficiently.