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

2 votes187 views1 answer
Mysql cannot delete or update a parent row
SQL
2 votes200 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote180 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote231 views1 answer
Pagination with row_number
SQL
0 vote210 views1 answer
Providername system.data. mysql
SQL
0 vote232 views1 answer
Capabilities of sql select statements
SQL
2 votes186 views1 answer
SQL column name Postgre
SQL
0 vote227 views1 answer
Doctors appointment
SQL
1 vote197 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
1 vote196 views1 answer
Postgresql escape single quote
SQL