MySQL) date_format

DATE_FORMAT(date, format)

- date : 날짜 형식을 지정할 date 데이터

- format : 날짜 형식

 

** format

format	description
%a	This abbreviation means weekday name. It’s limit is from Sun to Sat.
%b	This abbreviation means month name. It’s limit is from Jan to Dec.
%c	This abbreviation means numeric month name. It’s limit is from 0 to 12.
%D	This abbreviation means day of the month as a numeric value, followed by suffix like 1st, 2nd, etc.
%e	This abbreviation means day of the month as a numeric value. It’s limit is from 0 to 31.
%f	This abbreviation means microseconds. It’s limit is from 000000 to 999999.
%H	This abbreviation means hour. It’s limit is from 00 to 23.
%i	This abbreviation means minutes. It’s limit is from 00 to 59.
%j	This abbreviation means day of the year. It’s limit is from 001 to 366.
%M	This abbreviation means month name from January to December.
%p	This abbreviation means AM or PM.
%S	This abbreviation means seconds. It’s limit is from 00 to 59.
%U	This abbreviation means week where Sunday is the first day of the week. It’s limit is from 00 to 53.
%W	This abbreviation means weekday name from Sunday to Saturday.
%Y	This abbreviation means year as a numeric value of 4-digits.

 

참고 : https://www.geeksforgeeks.org/date_format-function-in-mysql/#:~:text=DATE_FORMAT()%20function%20in%20MySQL%20is%20used%20to%20format%20a,date%20as%20specified%20format%20parameters.&text=Parameter%20%3A%20This%20function%20accepts%20two,format%20%E2%80%93%20Specified%20format.