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

2 votes261 views1 answer
Sql select min value from multiple columns
SQL
0 vote315 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote263 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote287 views3 answers
Database restoring error
SQL
18 votes260 views2 answers
Sql comments
SQL
0 vote272 views3 answers
ChAnge TABLE name apex oracle
SQL
35 votes289 views6 answers
Postgres
SQL
38 votes326 views6 answers
Alter table mysql
SQL
48 votes321 views3 answers
Psql create database
SQL
3 votes318 views2 answers
Wp do sql query from function
SQL