Date in mysql

Mysql format date

DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats

Source: mysqltutorial.org

Mysql current date

SELECT NOW();
It returns current date and time.

Convert_tz mysql

CONVERT_TZ(datetime, from_tz, to_tz)

Example: 
SELECT CONVERT_TZ('2031-09-21 02:42:14', 'UTC', 'America/New_York');
output: 2031-09-20 22:42:14

Mysql current time

CURRENT_TIME return HH:ii:ss format time in mysql

Date in mysql

YYYY-MM-DD

--April 21 2021 would be
'2021-04-21'

--June 5 1944 would be
'1944-06-05'

Similar codes

0 vote174 views3 answers
ChAnge TABLE name apex oracle
SQL
4 votes168 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote186 views1 answer
Nosql vs sql
SQL
9 votes159 views4 answers
Add primary key to existing table sql
SQL
-1 vote165 views1 answer
Sql syntax create timestamp column
SQL
0 vote176 views1 answer
Postgres data location
SQL
0 vote178 views1 answer
Oracle gather table statistics
SQL
3 votes181 views1 answer
Sql multi column index performance
SQL
0 vote176 views1 answer
Except in sql
SQL
0 vote174 views1 answer
Postgresql print variable
SQL