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

3 votes219 views1 answer
Ms sql skip take
SQL
0 vote227 views1 answer
Psql store procedure-return multiple table values
SQL
15 votes216 views2 answers
How to drop database name in postgresql
SQL
0 vote223 views4 answers
Forenkey code alchemy sql
SQL
0 vote234 views1 answer
Possgress drop if exists view
SQL
0 vote244 views1 answer
Postgresql delete type
SQL
0 vote260 views1 answer
Hue hive UploadingTextFiletoHive
SQL
5 votes227 views2 answers
Oracle rename table
SQL
2 votes220 views1 answer
Oracle table size
SQL
0 vote226 views1 answer
Postgresql remove new line from string
SQL