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 vote386 views1 answer
GROUP BY postgres
SQL
0 vote347 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote360 views1 answer
Like date sql server not working
SQL
0 vote329 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
1 vote360 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote392 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote359 views2 answers
Postgres having
SQL
0 vote354 views3 answers
Osx stop mysql service
SQL
6 votes340 views4 answers
Eloquent to sql with bindings
SQL
0 vote351 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL