/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 vote222 views1 answer
Query string starts with vowels
SQL
0 vote194 views1 answer
Set column in all row mysql
SQL
0 vote202 views1 answer
Test the postgresql db connection
SQL
0 vote228 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote231 views1 answer
Sql show founctions
SQL
3 votes287 views6 answers
Jwt laravel
SQL
0 vote201 views7 answers
Les jointures sql server
SQL
3 votes215 views2 answers
Sql get month name
SQL
2 votes248 views1 answer
Show max_allowed_packet mysql
SQL
3 votes252 views1 answer
RENAME table pl sql
SQL

Share