/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

1 vote275 views2 answers
Mysql between
SQL
0 vote251 views1 answer
How to connect to mysql in ef 6
SQL
4 votes260 views1 answer
Oracle table statistics last analyzed
SQL
10 votes323 views4 answers
Join multiple tables in sql
SQL
3 votes280 views1 answer
Sql case update
SQL
14 votes262 views3 answers
SQL trim
SQL
7 votes270 views3 answers
Convert ansi sql
SQL
0 vote280 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote291 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
27 votes323 views3 answers
Mysql delete row
SQL

Share