SQL/programmers

String && date 모음

자동차 대여 기록에서 장기/단기 구분 - case, date_format, datediff 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 조회수가 가장 많은 중고 거래 게시판 - concat , join,..