/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 vote391 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote370 views2 answers
Uninstall postgresql mac
SQL
5 votes344 views3 answers
String concatenation sql server
SQL
0 vote340 views1 answer
Provera dupliranih konatakata
SQL
2 votes334 views1 answer
Oracle cpu per session
SQL
15 votes360 views5 answers
Show tables in oracle
SQL
4 votes314 views1 answer
Sql list users and roles
SQL
0 vote390 views1 answer
Sqlite unique multiple columns
SQL
0 vote354 views1 answer
Mysql pv progres
SQL
31 votes350 views4 answers
How to get duplicate records with multiple field in sql
SQL

Share