Sql

You can use MySQL's DATE() function:

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

WHERE datetime LIKE '2009-10-20%'

PREVIOUS	NEXT

Code Example
Sql :: ora-02391
Sql :: tsql cmd exec script from file
Sql :: mysql error incompatible with sql_mode=only_full_group_by
Sql :: sql update from different table
Sql :: cast to float with .2 sql
Sql :: mysql remote connection command line
Sql :: how to alter table column name in mysql
Sql :: mssql how to insert more than 1000 rows
Sql :: mysql does sentence contain word
Sql :: MySQL shutdown unexpectedly.
Sql :: psql connect
Sql :: sql decimal to 2 places
Sql :: sql in sublime
Sql :: mysql remove duplicates
Sql :: query saurce oracle
Sql :: sql order by ascending
Sql :: get only structure database mysql
Sql :: sql truncate statement
Sql :: db.Database.SqlQuery
Sql :: convert date to dd/mm/yyyy sql
Sql :: postgresql cast
Sql :: sql query duplicate rows
Sql :: postgresql create user
Sql :: oracle drop temporary table
Sql :: When mysql server would not work in xampp
Sql :: sql upsert
Sql :: postgresql insert column
Sql :: create table in sql
Sql :: sql update table set text to lowercase
Sql :: show the colums of table sql