/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

3 votes136 views1 answer
Sql online test questions and answers
SQL
7 votes120 views3 answers
Sql get last inserted row
SQL
0 vote122 views1 answer
Db format in quotation
SQL
3 votes106 views1 answer
Oracle failed login attempts
SQL
0 vote125 views1 answer
Check connections to database postgres
SQL
0 vote134 views1 answer
Postgresql port 5432 not open
SQL
0 vote139 views1 answer
Time data type in mysql
SQL
0 vote117 views1 answer
Group by two columns postgres
SQL
3 votes111 views1 answer
Oracle undo tablespace list by user
SQL
0 vote145 views2 answers
Remove mysql workbench ubuntu
SQL

Share