SELECT DATE_FORMAT("2010-08-30 21:19:58", "%m-%e-%Y %h:%i%s%p %W");
mysql>
mysql> SELECT DATE_FORMAT("2010-08-30 21:19:58", "%m-%e-%Y %h:%i%s%p %W");
+-------------------------------------------------------------+
| DATE_FORMAT("2010-08-30 21:19:58", "%m-%e-%Y %h:%i%s%p %W") |
+-------------------------------------------------------------+
| 08-30-2010 09:1958PM Monday |
+-------------------------------------------------------------+
1 row in set (0.00 sec)
Related examples in the same category
| 1. | Format a date 1 | | |
| 2. | Format a date 2 | | |
| 3. | Format a date 3 | | |
| 4. | Format a date 4 | | |
| 5. | Format a date 5 | | |
| 6. | Date Symbols in DATE_FORMAT, TIME_FORMAT, and FROM_UNIXTIME | | |
| 7. | Time Symbols in DATE_FORMAT, TIME_FORMAT, and FROM_UNIXTIME | | |
| 8. | Common used flags for DATE_FORMAT() | | |
| 9. | DATE_FORMAT Specifiers | | |
| 10. | DATE_FORMAT function | | |
| 11. | SELECT DATE_FORMAT('2005-12-31', '%M %d %Y') | | |
| 12. | SELECT DATE_FORMAT('2005-12-31', '%D of %M') | | |
| 13. | To return the birthdays of all staff in the format MM/DD/YYYY, use the DATE_FORMAT() function | | |
| 14. | SELECT DATE_FORMAT("2010-08-30 21:19:58", "%W %M %d %Y"); | | |
| 15. | SELECT DATE_FORMAT("2010-08-30 21:19:58", "%a. %b %e, '%y"); | | |
| 16. | SELECT DATE_FORMAT("2010-08-30 21:19:58", "%m-%e-%Y %l:%i%p"); | | |
| 17. | SELECT DATE_FORMAT("2010-08-30 21:19:58", "%M %D,%Y %k:%i CST %W"); | | |
| 18. | Formatting Dates and Times | | |
| 19. | SELECT @@GLOBAL.DATETIME_FORMAT | | |
| 20. | SET @@SESSION.DATETIME_FORMAT = DEFAULT | | |
| 21. | Decomposing Dates and Times Using Formatting Functions | | |
| 22. | Telling MySQL How to Display Dates or Times | | |
| 23. | The DATE and TIME data types use the following format: | | |
| 24. | Present a date differently than in CCYY-MM-DD format or present a time without the seconds part | | |
| 25. | Calculating One Date from Another by Substring Replacement | | |
| 26. | The string replacement technique can be used to produce dates with a specific position within the calendar year | | |
| 27. | For Christmas, replace the month and day with 12 and 25: | | |
| 28. | %a is the abbreviated weekday name, %D is the day of month with the suffix attached, %b is the abbreviated mon | | |