/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

10 votes108 views2 answers
Sql where clause multiple values
SQL
1 vote200 views1 answer
Oracle see column type
SQL
2 votes147 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote141 views1 answer
Hive batch drop table
SQL
0 vote153 views1 answer
Error code 1451 sql
SQL
2 votes140 views1 answer
Sqlite show table indexes
SQL
1 vote147 views1 answer
Postgresql float 2 decimal places
SQL
5 votes132 views1 answer
Alter table add comment oracle
SQL
4 votes149 views3 answers
Sql drop primary key
SQL
0 vote125 views1 answer
Phpmyadmin mysql conflict
SQL

Share