/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 vote316 views1 answer
Sql inserted
SQL
0 vote339 views1 answer
SAP Return
SQL
12 votes349 views10 answers
Google
SQL
1 vote308 views1 answer
Mysql column start with string
SQL
6 votes316 views2 answers
Mysql check auto increment value
SQL
0 vote339 views1 answer
Group by two columns postgres
SQL
0 vote354 views1 answer
Sqlite woth cmake
SQL
-2 votes340 views1 answer
Trunc in sql
SQL
1 vote316 views1 answer
How to get alternate records from a table in sql
SQL
4 votes316 views1 answer
Oracle delete last row
SQL

Share