/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 vote156 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote187 views1 answer
Nuget sqllite-net-pcl
SQL
6 votes249 views1 answer
How to count number of rows in sql
SQL
0 vote245 views1 answer
Mariadb hours between two dates
SQL
0 vote172 views1 answer
Xampp mysql version
SQL
21 votes231 views6 answers
Update sql
SQL
0 vote172 views2 answers
Postgresql gset
SQL
1 vote160 views1 answer
Sql auto timestamp
SQL
2 votes165 views3 answers
Current month mysql query
SQL
0 vote171 views1 answer
Left join vs inner join performance
SQL

Share