/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

5 votes315 views1 answer
How to check nls format in oracle
SQL
0 vote334 views1 answer
Postgres get database encoding
SQL
1 vote328 views1 answer
Deleting database in sql
SQL
0 vote298 views1 answer
Mysql local password denied
SQL
17 votes319 views6 answers
Get last record in sql
SQL
7 votes273 views1 answer
Alter table add key sql
SQL
1 vote307 views1 answer
Alter table column size oracle
SQL
2 votes378 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
10 votes349 views4 answers
Mysql if else
SQL
10 votes307 views2 answers
Forgot my mysql password mac
SQL

Share