/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

1 vote145 views1 answer
Sql select whole row max column
SQL
0 vote145 views1 answer
Setval in postgres
SQL
0 vote144 views1 answer
Mysql workbench procedure
SQL
0 vote150 views1 answer
Mysql custom sort order
SQL
-1 vote136 views1 answer
How to check table exists or not in postgresql
SQL
8 votes137 views3 answers
Connect python to mysql
SQL
0 vote171 views2 answers
Sql update multiple tables
SQL
1 vote131 views3 answers
Read all columns of a table sql
SQL
3 votes136 views2 answers
Mysql time
SQL
3 votes149 views1 answer
Oracle cannot access v$session
SQL

Share