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 vote278 views1 answer
Mariadb select limit offset
SQL
0 vote279 views1 answer
Pl/ sql change currency
SQL
1 vote290 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote384 views5 answers
Right join
SQL
0 vote277 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote272 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote312 views1 answer
Stratified sampling sql
SQL
0 vote250 views1 answer
T sql return on letters only
SQL
1 vote264 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote275 views1 answer
How to input data as id in database sql c#
SQL