[날짜 포매팅] maria db 날짜 데이터 yyyy-mm-dd로 출력하기

기록용

 

 

unionmembers 테이블 구조:

id	int(11)	NO	PRI	[NULL]	auto_increment
guild_members_id	int(11)	YES		[NULL]
member_name	varchar(12)	YES		[NULL]
character_level	int(11)	YES		[NULL]
offensive_power	varchar(10)	YES		[NULL]
character_class_level	int(11)	YES		[NULL]
character_class	varchar(30)	YES		[NULL]
union_member_name	varchar(12)	YES		[NULL]
union_level	varchar(5)	YES		[NULL]
union_power	varchar(12)	YES		[NULL]
regist_date	datetime	YES		[NULL]
update_date	datetime	YES		[NULL]
error_code	varchar(12)	YES		[NULL]

 

쿼리

SELECT DATE_FORMAT(regist_date, '%Y-%m-%d') AS formatted_regist_date
FROM unionmembers;