SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

by

Since your input is a string in the form 03.09.13, I’ll assume (since today is September 3, 2013) that it’s dd.mm.yy. You can convert it to a date using STR_TO_DATE:

STR_TO_DATE(myVal, '%d.%m.%y')

Then you can format it back to a string using DATE_FORMAT:

DATE_FORMAT(STR_TO_DATE(myVal, '%d.%m.%y'), '%Y-%m-%d')

Note that the year is %y (lowercase “y”) in STR_TO_DATE and %Y (uppercase “Y”) in DATE_FORMAT. The lowercase version is for two-digit years and the uppercase is for four-digit years.

More Related Contents:

  1. Left Outer Join doesn’t return all rows from my left table?
  2. Get a list of dates between two dates
  3. How to populate a table with a range of dates?
  4. MySQL Query GROUP BY day / month / year
  5. Error in MySQL when setting default value for DATE or DATETIME
  6. Difference between two dates in MySQL
  7. Get the latest date from grouped MySQL data
  8. How to select the most recent set of dated records from a mysql table
  9. Compare only day and month with date field in mysql
  10. Insert/ Update random date in MySQL
  11. Why MySQL is giving error “Not allowed to return a result set from a function”?
  12. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  13. How do I extract Month and Year in a MySQL date and compare them?
  14. Recreating a query using INNER JOIN? [duplicate]
  15. Create a Cumulative Sum Column in MySQL
  16. MySQL Trigger after update only if row has changed
  17. MySQL “WITH” clause
  18. mysql select dynamic row values as column names, another column as value
  19. MySQL Query – Records between Today and Last 30 Days
  20. MySQL “Group By” and “Order By”
  21. MySQL Query to select data from last week?
  22. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  23. Simple Random Samples from a Sql database
  24. How to select date from datetime column?
  25. How do I use properly CASE..WHEN in MySQL
  26. Delete query not working in mysql
  27. How to insert data to MySQL with auto-incremented column(field)?
  28. MySql – How get value in previous row and value in next row? [duplicate]
  29. Updating table in trigger after update on the same table
  30. MySQL 5.6 – DENSE_RANK like functionality without Order By

Leave a Comment