-- answer
SELECT USED_GOODS_BOARD.TITLE,
USED_GOODS_BOARD.BOARD_ID,
USED_GOODS_REPLY.REPLY_ID,
USED_GOODS_REPLY.WRITER_ID,
USED_GOODS_REPLY.CONTENTS,
DATE_FORMAT(USED_GOODS_REPLY.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE
FROM USED_GOODS_BOARD,
USED_GOODS_REPLY
WHERE USED_GOODS_BOARD.BOARD_ID = USED_GOODS_REPLY.BOARD_ID
AND USED_GOODS_BOARD.CREATED_DATE BETWEEN '2022-10-01'
AND '2022-10-31'
ORDER BY USED_GOODS_REPLY.CREATED_DATE,
USED_GOODS_BOARD.TITLE;
여기서 00:00:00을 지울 필요가 있습니다.
MySQL 사이트 에 들어가보시면 이렇게 포맷이 나오는데, 이 포맷을 따라 코드를 작성해주시면 원하시는 포맷으로 날짜를 출력하실 수 있습니다.
DATE_FORMAT(USED_GOODS_REPLY.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE
-- answer
SELECT BOARD.TITLE,
BOARD.BOARD_ID,
REPLY.REPLY_ID,
REPLY.WRITER_ID,
REPLY.CONTENTS,
DATE_FORMAT(REPLY.CREATED_DATE, '%Y-%m-%d') AS CREATED_DATE
FROM USED_GOODS_BOARD AS BOARD,
USED_GOODS_REPLY AS REPLY
WHERE BOARD.BOARD_ID = REPLY.BOARD_ID
AND BOARD.CREATED_DATE BETWEEN '2022-10-01'
AND '2022-10-31'
ORDER BY REPLY.CREATED_DATE,
BOARD.TITLE;
-- AS문 활용하여 축약 활용
FROM USED_GOODS_BOARD AS BOARD,
USED_GOODS_REPLY AS REPLY