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 vote181 views1 answer
Oracle execute package dblink
SQL
6 votes172 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote151 views1 answer
Update set with inner join oracle
SQL
11 votes159 views2 answers
MySQL DISTINCT
SQL
0 vote176 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote158 views3 answers
String to int mysql
SQL
0 vote198 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote148 views1 answer
Sql server cannot create database diagram
SQL
0 vote177 views1 answer
Mysql conf.d exampel
SQL
1 vote118 views1 answer
Into sql
SQL