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 votes185 views1 answer
Psql get sequences
SQL
0 vote183 views1 answer
Json_remove mysql
SQL
0 vote202 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote194 views1 answer
Hibernate with springboot mysql
SQL
3 votes191 views1 answer
Index using in query plsql
SQL
3 votes186 views4 answers
Order by desc postgres
SQL
0 vote193 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
4 votes183 views1 answer
Oracle table statistics last analyzed
SQL
0 vote196 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
25 votes231 views6 answers
Import database mysql command line
SQL