/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

12 votes203 views1 answer
Run mysql instance in docker
SQL
0 vote194 views1 answer
Postgresql replace html tags from string
SQL
0 vote193 views1 answer
Insert ip address in mysql
SQL
0 vote207 views1 answer
Second Step in installing SQL workbench
SQL
1 vote173 views1 answer
Floor function in sql oracle
SQL
0 vote221 views1 answer
Mysql config address
SQL
7 votes177 views1 answer
Sql server convert string to date
SQL
5 votes206 views1 answer
Oracle create table comment
SQL
2 votes311 views1 answer
Mysql create user with remote access
SQL
0 vote180 views1 answer
Mysql set column equal to another automatic
SQL

Share