/SQL/Mysql get date from datetime

Mysql get date from datetime

Mysql get time from datetime

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

3

How to get the date from datetime in mysql

SELECT DATE(ColumnName) FROM tablename;

1

Mysql current time

CURRENT_TIME return HH:ii:ss format time in mysql

1

Mysql get date from datetime

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

-1

Source: stackoverflow.com

Similar codes

0 vote113 views1 answer
Mysql add comment to column
SQL
0 vote133 views1 answer
Play framework connection via windows sql server
SQL
5 votes123 views3 answers
Truncate function in sql oracle
SQL
1 vote112 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
12 votes120 views2 answers
Delete all entries postgres
SQL
22 votes153 views4 answers
Mysql format date
SQL
0 vote114 views1 answer
Codeigniter dbforge add index
SQL
0 vote152 views1 answer
For select oracle
SQL
1 vote104 views1 answer
Mysql count all table rows
SQL
0 vote113 views1 answer
Codeigniter 3 get best-selling products
SQL

Share