Answers for "mysql datetime where clause sql query"

SQL
1

date in where on datetime column clause mysql

You can use MySQL's DATE() function:

WHERE DATE(datetime) = '2009-10-20'
You could also try this:

WHERE datetime LIKE '2009-10-20%'
Posted by: Guest on February-15-2021

Code answers related to "mysql datetime where clause sql query"

Code answers related to "SQL"

Browse Popular Code Answers by Language