/SQL/Mysql select date from datetime

Mysql select date from datetime

How to get the date from datetime in mysql

SELECT DATE(ColumnName) FROM tablename;

1

Mysql select date from datetime

WHERE DATE(datetime) = '2009-10-20'

-1

Source: stackoverflow.com

Similar codes

8 votes197 views2 answers
Safe update mode in mysql
SQL
0 vote190 views1 answer
Group_concat only returns one row
SQL
1 vote235 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote204 views1 answer
How to display value of variable in mysql
SQL
0 vote176 views1 answer
How to change null display in psql
SQL
0 vote189 views1 answer
How to get inserted id in sql server
SQL
0 vote180 views1 answer
Sqlite to csv statement
SQL
0 vote185 views1 answer
How to search query in python3 sqlite3
SQL
0 vote196 views1 answer
Comparing with today and yesterday record in sql query
SQL
8 votes240 views2 answers
Default sql server port
SQL

Share