日期字符的转换

Select ROUND(TO_NUMBER(to_date(to_char(Sysdate,'yyyy-MM-dd'),'yyyy-MM-dd')-to_date('2007-3-25','yyyy-MM-dd'))) v_ggts Into v_sxts From dual;