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 vote198 views1 answer
Sqlite3 get data from table c
SQL
0 vote190 views1 answer
Mysql with
SQL
1 vote216 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote199 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote210 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote208 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote217 views1 answer
Select tables with name like mysql
SQL
0 vote182 views1 answer
Postgresql inline table
SQL
0 vote254 views1 answer
How to add auto increment primary key
SQL
0 vote201 views1 answer
How to create a new db from dumb file mysql
SQL