Specific Date Format in mysql

by

You can use DATE_FORMAT with the format string ‘%d-%M-%Y’.

CREATE TABLE table1(ID varchar(100), Date datetime);
INSERT INTO table1 VALUES
('001', '2010-05-01'),
('002', '2010-06-08');

SELECT ID, DATE_FORMAT(Date, '%d-%M-%Y') FROM table1;

Result:

ID    Date
001   01-May-2010
002   08-June-2010

More Related Contents:

  1. How do you set a default value for a MySQL Datetime column?
  2. Compare two MySQL databases [closed]
  3. MySQL – Trigger for updating same table after insert
  4. Storing image in database directly or as base64 data?
  5. Implementation of Levenshtein distance for mysql/fuzzy search?
  6. Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?
  7. MySQL – Operand should contain 1 column(s)
  8. Restore table structure from frm and ibd files
  9. Can a number be used to name a MySQL table column?
  10. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  11. mysql pivot/crosstab query
  12. UNION query with codeigniter’s active record pattern
  13. When to use MongoDB or other document oriented database systems? [closed]
  14. Remove Primary Key in MySQL
  15. MySQL grant all privileges to database except one table
  16. mysql stored procedure that calls itself recursively
  17. MySql views performance [closed]
  18. When to use NULL in MySQL tables
  19. How to get number of rows affected, while executing MySQL query from bash?
  20. What is the difference between tinyint, smallint, mediumint, bigint and int in MySQL?
  21. Detecting locked tables (locked by LOCK TABLE)
  22. MySQL CURRENT_TIMESTAMP on create and on update
  23. Access denied after setting user’s password with SHA256 in phpMyAdmin
  24. connecting MySQL server to NetBeans
  25. How does MySQL handle concurrent inserts?
  26. Put MySQL database under version control?
  27. How do I combine the results of two queries with ordering?
  28. How we can find domain name using MySQL and regular expression
  29. Convert SQL Server query to MySQL [duplicate]
  30. Dump only the data with mysqldump without any table information?

Leave a Comment