将下面这个SQL转为Oracle的SQLSELECT id room_no begin_date end_date use_dateFROM t_meeting_room_reserveWHERE use_date BETWEEN CURDATE AND DATE_ADDCURDATE INTERVAL 7 DAY
SELECT id, room_no, begin_date, end_date, use_date FROM t_meeting_room_reserve WHERE use_date BETWEEN SYSDATE AND SYSDATE+7;
原文地址: https://www.cveoy.top/t/topic/Fwg 著作权归作者所有。请勿转载和采集!