2024-01-25

SQL

ifnull(data, 0)
DATE_FORMAT(HIRE_YMD, '%Y-%m-%d')

SELECT
    HISTORY_ID,
    CAR_ID,
    DATE_FORMAT(START_DATE, '%Y-%m-%d') AS START_DATE,
    DATE_FORMAT(END_DATE, '%Y-%m-%d') AS END_DATE,
    CASE
        WHEN DATEDIFF(END_DATE, START_DATE) >= 29 THEN '장기 대여'
        ELSE '단기 대여'
    END AS RENT_TYPE
FROM
    CAR_RENTAL_COMPANY_RENTAL_HISTORY
WHERE START_DATE LIKE "2022-09%"
ORDER BY HISTORY_ID DESC

SQL에 사용되는 함수들이다.

CASE, DATE_FORMAT, ifnull을 숙지하고 있으면 좋을것 같다.