Mysql date to string

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 date to string

  -- Convert the current date to YYYYMM format
  SELECT DATE_FORMAT(NOW(), '%Y%m');
  # 201302

Source: sqlines.com

Similar codes

0 vote120 views1 answer
Pl/pgsql declare variable
SQL
21 votes103 views4 answers
Add column mssql
SQL
0 vote110 views2 answers
How to display enum value sql server
SQL
6 votes105 views2 answers
Mysql check auto increment value
SQL
1 vote91 views1 answer
Avg mysql
SQL
0 vote110 views1 answer
Exit psql
SQL
0 vote163 views3 answers
How to find all role in mysql
SQL
1 vote115 views1 answer
How to group by month using sql server
SQL
3 votes103 views4 answers
Truncate syntax in sql
SQL
0 vote103 views1 answer
Like and not like together in sql
SQL