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

4 votes333 views2 answers
Postgres update single column
SQL
21 votes336 views1 answer
Cheatsheet for sql
SQL
0 vote318 views1 answer
View acl table oracle
SQL
1 vote317 views1 answer
Get url of cpanel database hostname
SQL
0 vote343 views2 answers
Mysql on update current_timestamp
SQL
0 vote326 views1 answer
List mysql tables and views
SQL
-1 vote358 views1 answer
Pl/sql how to delete a trigger
SQL
3 votes459 views1 answer
How to get yesterday date in sql
SQL
-1 vote362 views3 answers
Error: mysql shutdown unexpectedly.
SQL
10 votes349 views6 answers
Sql between
SQL