The DATE and TIME data types use the following format:

      

YYYY-MM-DD HH:MM:SS

where:

YYYY represents the year

MM represents the month

DD represents the day

HH represents the hour

MM represents the minute

SS represents the second

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-%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.	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

The DATE and TIME data types use the following format: : Date Format « Date Time « SQL / MySQL

Related examples in the same category