将天数转x年x月x天

Java版本：

        int daycount=70;//天数
        int year=daycount/365;
        int month=(daycount-(year*365))/30;
        int day=daycount-(year*365)-(month*30);
        String java=year+"年"+month+"月"+day+"天";
        System.out.println(java);

Oracle版本：

        String daycount="1000";
        String year="(floor("+daycount+"/365))";
        String month="(floor(("+daycount+"-("+year+"*365))/30))";
        String day="("+daycount+"-("+year+"*365)-("+month+"*30))";
        String oracle="select to_char"+year+"||'年'||to_char"+month+"||'月'||to_char"+day+"||'天'  from dual";
        System.out.println(oracle);