Date Format « Date Time « SQL / MySQL

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-%e-%Y %h:%i%s%p %W");

18.

SELECT DATE_FORMAT("2010-08-30 21:19:58", "%M %D,%Y %k:%i CST %W");

19.

Formatting Dates and Times

20.

SELECT @@GLOBAL.DATETIME_FORMAT

21.

SET @@SESSION.DATETIME_FORMAT = DEFAULT

22.

Decomposing Dates and Times Using Formatting Functions

23.

Telling MySQL How to Display Dates or Times

24.

The DATE and TIME data types use the following format:

25.

Present a date differently than in CCYY-MM-DD format or present a time without the seconds part

26.

Calculating One Date from Another by Substring Replacement

27.

The string replacement technique can be used to produce dates with a specific position within the calendar year

28.

For Christmas, replace the month and day with 12 and 25:

29.

%a is the abbreviated weekday name, %D is the day of month with the suffix attached, %b is the abbreviated mon