Converting a date in MySQL from string field

by

This:

STR_TO_DATE(t.datestring, '%d/%m/%Y')

…will convert the string into a datetime datatype. To be sure that it comes out in the format you desire, use DATE_FORMAT:

DATE_FORMAT(STR_TO_DATE(t.datestring, '%d/%m/%Y'), '%Y-%m-%d')

If you can’t change the datatype on the original column, I suggest creating a view that uses the STR_TO_DATE call to convert the string to a DateTime data type.

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 convert a string to date in MySQL?
  4. Error in MySQL when setting default value for DATE or DATETIME
  5. How to get the number of days of difference between two dates on MySQL?
  6. MySQL: Select All Dates In a Range Even If No Records Present
  7. Difference between two dates in MySQL
  8. CURRENT_DATE/CURDATE() not working as default DATE value
  9. How to get difference between two dates in months using MySQL query?
  10. How do I select between the 1st day of the current month and current day in MySQL?
  11. Get the latest date from grouped MySQL data
  12. How to get an age from a D.O.B field in MySQL?
  13. mysql: get record count between two date-time
  14. How to get first day of every corresponding month in mysql?
  15. Count days between two dates, excluding weekends (MySQL only)
  16. How to select the most recent set of dated records from a mysql table
  17. How do I get the first day of the week of a date in mysql?
  18. MySQL date format
  19. MySQL: How to select records for this week?
  20. Compare only day and month with date field in mysql
  21. MySQL – select data from database between two dates
  22. How to select only date from a DATETIME field in MySQL?
  23. Insert/ Update random date in MySQL
  24. How to compare timestamp dates with date-only parameter in MySQL?
  25. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  26. MySQL cumulative sum grouped by date
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. MySQL: Find Missing Dates Between a Date Range
  29. How do I extract Month and Year in a MySQL date and compare them?
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment