
SELECT book_id, date_format(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE
FROM BOOK
WHERE category = '인문'
AND PUBLISHED_DATE LIKE '2021%'
ORDER BY PUBLISHED_DATE ASC;
Share article
SELECT book_id, date_format(PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE
FROM BOOK
WHERE category = '인문'
AND PUBLISHED_DATE LIKE '2021%'
ORDER BY PUBLISHED_DATE ASC;
stupefyee