mySQL convert varchar to date

by 
select date_format(str_to_date('31/12/2010', '%d/%m/%Y'), '%Y%m');

or

select date_format(str_to_date('12/31/2011', '%m/%d/%Y'), '%Y%m');

hard to tell from your example

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. Get records with max value for each group of grouped SQL results
  3. Select all columns except one in MySQL?
  4. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  5. MySQL Conditional Insert
  6. How to properly create composite primary keys – MYSQL
  7. Is there a MySQL option/feature to track history of changes to records?
  8. MySQL JOIN ON vs USING?
  9. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  10. Using an Alias in SQL Calculations
  11. How to get difference between two dates in months using MySQL query?
  12. How to change the foreign key referential action? (behavior)
  13. MySQL – Control which row is returned by a group by
  14. Can MySQL replace multiple characters?
  15. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  16. Using ORDER BY and GROUP BY together
  17. How can VBA connect to MySQL database in Excel?
  18. MySQL Pivot Table Column Data as Rows
  19. updating columns with a sequence number mysql
  20. How repair corrupt xampp ‘mysql.user’ table?
  21. Select a column with a keyword name
  22. What is the MySQL query equivalent of PHP strip_tags?
  23. Select all months within given date span, including the ones with 0 values
  24. Use Composite Primary Key as Foreign Key
  25. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  26. GRANT with database name wildcard in MySQL?
  27. Using SUM on FLOAT data
  28. Duplicate entry for key ‘group_key’
  29. SQL query with avg and group by
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment