Sql

SELECT DATE(ColumnName) FROM tablename;

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

PREVIOUS	NEXT

Code Example
Sql :: sample clause in sql
Sql :: drop function in sql
Sql :: sql query to find percentage of null values in a table
Sql :: SQL check if record exist
Sql :: datepart sql server
Sql :: GROUP BY With HAVING Clausel
Sql :: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "con" is null
Sql :: INITCAP in Oracle example
Sql :: postgre insert select
Sql :: how to run a function in sql
Sql :: sqlite3 update select
Sql :: sql pass table name as variable
Sql :: show table mysql
Sql :: sql select if not exists
Sql :: select true if exists on another table or false sqlserver
Sql :: postgresql conectar
Sql :: grant all privileges database postgres to user
Sql :: auto increment column in mysql query results
Sql :: sql restore backup query
Sql :: get locked tables sql server
Sql :: uncheck constraints and delete from table
Sql :: sql where contains part of string
Sql :: how to define a save method in ruby for sqlite3 databases
Sql :: sql restore database from backup
Sql :: sql if null then string
Sql :: mysql regexp replace
Sql :: psql check if value in array
Sql :: android sqlite query join
Sql :: See Foreign Key
Sql :: mysql default port number