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 vote355 views1 answer
Oracle change password expiration policy
SQL
1 vote324 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote373 views1 answer
Store case result sql
SQL
1 vote336 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
5 votes354 views1 answer
Oracle get foreign keys on table
SQL
18 votes368 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote360 views1 answer
Replace content value from old to new sql
SQL
0 vote336 views1 answer
Sql server whoami
SQL
0 vote338 views1 answer
How to to get current date and time in sql
SQL
0 vote389 views1 answer
Querry mysql by 2 columns
SQL