How to select only date from a DATETIME field in MySQL?

by

SELECT DATE(ColumnName) FROM tablename;

More on MySQL DATE() function.

More Related Contents:

  1. How to populate a table with a range of dates?
  2. How to convert a string to date in MySQL?
  3. MySQL Query GROUP BY day / month / year
  4. How to get the number of days of difference between two dates on MySQL?
  5. Converting a date in MySQL from string field
  6. MySQL: Select All Dates In a Range Even If No Records Present
  7. Mysql: Select all data between two dates
  8. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  9. MySQL Query – Records between Today and Last 30 Days
  10. Difference between two dates in MySQL
  11. CURRENT_DATE/CURDATE() not working as default DATE value
  12. How to get difference between two dates in months using MySQL query?
  13. Select mysql query between date?
  14. How to select date from datetime column?
  15. mysql: get record count between two date-time
  16. How to get first day of every corresponding month in mysql?
  17. Count days between two dates, excluding weekends (MySQL only)
  18. How to select the most recent set of dated records from a mysql table
  19. How to cast DATETIME as a DATE in mysql?
  20. MySQL date format
  21. Compare only day and month with date field in mysql
  22. Select all months within given date span, including the ones with 0 values
  23. Update date + one year in mysql
  24. mysql date comparison with date_format
  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