Sql

SELECT 
date_format(datecol, '%H:%i:%s') as 'time' FROM table;
-- eg. 10:33:10

SELECT DATE(ColumnName) FROM tablename;

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

PREVIOUS	NEXT

Code Example
Sql :: sample in sql
Sql :: sql rtrim
Sql :: open postgresql.conf
Sql :: mysql function
Sql :: inner join
Sql :: activate binary log mariadb
Sql :: sql max of two values
Sql :: limit offset sql server
Sql :: sql remove duplicates
Sql :: sql server current time without date
Sql :: postgresql default value
Sql :: oracle change tablespace size
Sql :: rollback in sql
Sql :: mysql not equal
Sql :: SQL Copy to Another Database
Sql :: SQLSTATE[01000]: Warning: 1265 Data truncated for column
Sql :: add column table pl sql
Sql :: postgres left join
Sql :: try catch sql
Sql :: creating sqeuence in oracle database
Sql :: select the date 30 days less that the todays date sql request
Sql :: sql stored procedure with table parameter
Sql :: how to define a save method in ruby for sql databases
Sql :: sql query to create table in database
Sql :: split string by comma in sql server
Sql :: sql union operator
Sql :: sql distinct clause
Sql :: datagrip exec
Sql :: change schema of all tables postgres
Sql :: mysql unique constraint