MySQL date format DD/MM/YYYY select query?

by

Guessing you probably just want to format the output date? then this is what you are after

SELECT *, DATE_FORMAT(date,'%d/%m/%Y') AS niceDate 
FROM table 
ORDER BY date DESC 
LIMIT 0,14

Or do you actually want to sort by Day before Month before Year?

More Related Contents:

  1. Delete the entire content of all table in a Database [closed]
  2. MyISAM versus InnoDB [closed]
  3. Calculate a running total in MySQL
  4. How can I use mySQL replace() to replace strings in multiple records?
  5. GROUP_CONCAT ORDER BY
  6. MySQL: ALTER TABLE if column not exists
  7. Find and Replace text in the entire table using a MySQL query
  8. MySQL SELECT increment counter
  9. Prevent auto increment on MySQL duplicate insert
  10. Query from two tables in report
  11. MySQL – force not to use cache for testing speed of query
  12. Is it safe to store usernames and passwords in the database?
  13. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  14. How to count all rows when using SELECT with LIMIT in MySQL query?
  15. MySQL FULL JOIN?
  16. How to fix double-encoded UTF8 characters (in an utf-8 table)
  17. How to integrate ElasticSearch with MySQL?
  18. MySQL INSERT INTO … VALUES and SELECT
  19. MySQL LOAD_FILE() loads null values
  20. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  21. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  22. How to compare timestamp dates with date-only parameter in MySQL?
  23. How to sort a MYSQL table in a permanent way?
  24. UPDATE with ORDER BY and LIMIT not working in MYSQL
  25. ALTER TABLE ADD COLUMN takes a long time
  26. MySQL Recursive get all child from parent
  27. Creating MYSQL Procedure in Laravel 4 Migrations
  28. is it possible to call a sql script from a stored procedure in another sql script?
  29. MySQL: Computed Column
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment