/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 vote178 views1 answer
Sqlite update from another table
SQL
2 votes175 views1 answer
Mysql select default if null
SQL
-1 vote166 views2 answers
On update cascade
SQL
0 vote171 views1 answer
Oracle date winter time
SQL
123 votes285 views5 answers
Sql where contains
SQL
0 vote196 views1 answer
How to inner join 4 tables in sql
SQL
0 vote184 views1 answer
Fetching data from mysqldb
SQL
0 vote185 views1 answer
Trigger vérifier stock
SQL
0 vote178 views2 answers
How to create a table from another table in sql derby
SQL
7 votes159 views1 answer
Append column sql
SQL

Share