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

1 vote310 views2 answers
Mysql order by date asc null last
SQL
0 vote334 views1 answer
Sql server on mac m1
SQL
0 vote315 views1 answer
How to query all tables mysql at the same time
SQL
0 vote322 views1 answer
How to display value of variable in mysql
SQL
2 votes328 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
7 votes336 views3 answers
Add primary key to database sql
SQL
1 vote324 views2 answers
How to search date in sql query
SQL
0 vote322 views2 answers
How to display enum value sql server
SQL
1 vote304 views1 answer
Postgres get timestamp
SQL
0 vote306 views1 answer
Mysql error codeigniter
SQL