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 vote225 views1 answer
What is SQL data store?
SQL
16 votes209 views2 answers
Gremove folder from git
SQL
17 votes270 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote216 views3 answers
Drop multiple columns in sql
SQL
0 vote235 views1 answer
Sql select max value for each group
SQL
0 vote246 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote232 views1 answer
Psql datetime grather than
SQL
3 votes238 views1 answer
Oracle list user grants
SQL
-1 vote220 views1 answer
Export mysql table to file
SQL
1 vote227 views1 answer
Best sql course
SQL