/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

7 votes126 views4 answers
What is my mysql version
SQL
0 vote128 views3 answers
Java hide mysql login credentials
SQL
0 vote139 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
1 vote132 views1 answer
DATE_SUB postgres
SQL
0 vote121 views1 answer
Acutal month year
SQL
5 votes125 views2 answers
Copy data from one database to another
SQL
17 votes138 views3 answers
How to change a collumn name in sql
SQL
10 votes119 views2 answers
Sql merge statement
SQL
1 vote135 views1 answer
Error code 1292 mysql workbench
SQL
0 vote118 views1 answer
Sql random decimal
SQL

Share