{"id":348,"date":"2020-12-22T09:23:34","date_gmt":"2020-12-22T01:23:34","guid":{"rendered":"http:\/\/www.linux-dba.com\/?p=348"},"modified":"2022-02-21T19:14:35","modified_gmt":"2022-02-21T11:14:35","slug":"oracle-%e8%ae%a1%e7%ae%97%e5%b9%b4%e9%be%84","status":"publish","type":"post","link":"http:\/\/www.linux-dba.com\/index.php\/2020\/12\/348\/","title":{"rendered":"oracle \u8ba1\u7b97\u5e74\u9f84"},"content":{"rendered":"\n<p>select floor(months_between(trunc(sysdate),date &#8216;1995-12-13&#8217;) \/ 12) age_years,<br>floor(mod(months_between(trunc(sysdate),date &#8216;1995-12-13&#8217;) , 12)) age_months,<br>mod(months_between(trunc(sysdate),date &#8216;1995-12-13&#8217;) , 1) * to_number(to_char(last_day(trunc(SYSDATE)), &#8216;DD&#8217;)) age_days<br>from dual<br>;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>select floor(months_between(trunc(sysdate),date &#8216; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[40],"tags":[4,57],"_links":{"self":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts\/348"}],"collection":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/comments?post=348"}],"version-history":[{"count":3,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts\/348\/revisions"}],"predecessor-version":[{"id":365,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts\/348\/revisions\/365"}],"wp:attachment":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/media?parent=348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/categories?post=348"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/tags?post=348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}