/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

2 votes383 views2 answers
Mysql write into table
SQL
4 votes320 views1 answer
Sql data types
SQL
2 votes361 views1 answer
Oracle list duplicates
SQL
1 vote326 views1 answer
Show table columns
SQL
2 votes398 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote334 views1 answer
Increase speed of like queries postgres
SQL
2 votes321 views1 answer
Delete all value query
SQL
2 votes326 views2 answers
Postgres set user as superuser
SQL
0 vote393 views1 answer
Install mysql on bash
SQL
0 vote374 views1 answer
Delete a temporary table mysql
SQL

Share