/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

0 vote68 views2 answers
Avg() sql
SQL
-1 vote101 views1 answer
How to use update trigger in sql
SQL
0 vote160 views1 answer
How to compile a function in oracle
SQL
0 vote111 views1 answer
Mysql count grouped rows
SQL
5 votes112 views2 answers
Create table mysql example auto_increment
SQL
3 votes112 views2 answers
Search text in all sql server stored procedure
SQL
0 vote170 views1 answer
Import sql dump into postgresql database
SQL
3 votes104 views1 answer
Start mysql server by terminal in linux
SQL
0 vote103 views1 answer
Postgresql update to unique
SQL
0 vote107 views1 answer
Top frequency in sql server
SQL

Share