/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 vote340 views1 answer
Oracle date winter time
SQL
0 vote338 views1 answer
Convert int to varchar sql
SQL
0 vote327 views1 answer
How to use lower case in mysql
SQL
1 vote332 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
2 votes371 views1 answer
Oracle Column Names of a table
SQL
0 vote325 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote364 views1 answer
Pl/pgsql declare variable
SQL
15 votes338 views1 answer
Mysql int range
SQL
6 votes342 views3 answers
Mysql change auto_increment start value
SQL
13 votes391 views3 answers
Mysqldump structure only
SQL

Share