Mysql-151138

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,'장기 대여' as RENT_TYPE
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
where START_DATE like '2022-09%'
and DATEDIFF(END_DATE,START_DATE)>=29
union
SELECT HISTORY_ID,CAR_ID,DATE_FORMAT(START_DATE,"%Y-%m-%d") as START_DATE,DATE_FORMAT(END_DATE,"%Y-%m-%d"),'단기 대여' as RENT_TYPE
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
where START_DATE like '2022-09%'
and DATEDIFF(END_DATE,START_DATE)<29
order by HISTORY_ID desc

DATE_FORMAT

• DATE_TIME을 원하는 포멧으로 변경

DATEDIFF

• 두 날짜의 일 차이를 계싼