/SQL/Date in where on datetime column clause mysql

Date in where on datetime column clause mysql

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%'

1

Source: stackoverflow.com

Similar codes

0 vote184 views1 answer
Mysql update table from select on another table
SQL
1 vote172 views1 answer
Search for tables with name postgresql
SQL
0 vote192 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote129 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote243 views1 answer
Mysql get longest string in column
SQL
3 votes189 views1 answer
DB: in eloquent using sql
SQL
15 votes177 views4 answers
How to get all tables in sql
SQL
11 votes170 views1 answer
How to get ddl for materialized view
SQL
1 vote184 views1 answer
Join first name and last name sql
SQL
16 votes195 views4 answers
Ascending order mysql
SQL

Share