oracle日期相减得到天数

select trunc(date1) - trunc(date2) from dual;

例如:

select (TRUNC(g2.CREATE_DATE) - TRUNC(g1.CREATE_DATE)) as "存放天数" from table1;