/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 vote106 views1 answer
How to to get current date in sql
SQL
2 votes117 views1 answer
Mysql id of inserted row
SQL
2 votes93 views1 answer
Oracle drop sequence if exists
SQL
0 vote58 views1 answer
Mysqli or pdo
SQL
0 vote118 views1 answer
Trigger stock phpmyadmin
SQL
0 vote116 views1 answer
USING THE NOT CONDITION IN SQL
SQL
2 votes115 views3 answers
Postgres json to string
SQL
0 vote103 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote103 views4 answers
Mysql replace regex
SQL
1 vote55 views1 answer
Python escape string for sql
SQL

Share