/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 vote261 views1 answer
Site:av.ru "files"
SQL
-1 vote220 views1 answer
Module operator in oracle sql
SQL
5 votes231 views2 answers
Sql server check port number
SQL
0 vote230 views1 answer
Sql get month from date
SQL
32 votes259 views6 answers
Rename column mysql
SQL
0 vote213 views1 answer
Parsing float to int in mysql
SQL
0 vote244 views1 answer
Sql change primary key to composite key
SQL
11 votes245 views3 answers
How to get last row of table in sql
SQL
23 votes244 views3 answers
Sql where contains part of string
SQL
0 vote228 views1 answer
Psql datestyle
SQL

Share