{"id":97,"date":"2020-07-10T12:02:00","date_gmt":"2020-07-10T03:02:00","guid":{"rendered":"http:\/\/www.shamonabe.com\/?p=97"},"modified":"2020-07-10T12:03:58","modified_gmt":"2020-07-10T03:03:58","slug":"post-97","status":"publish","type":"post","link":"http:\/\/www.shamonabe.com\/?p=97","title":{"rendered":"to_char\u3068to_date"},"content":{"rendered":"<p>\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u30e1\u30e2<\/p>\n<p>\u30fb\u57fa\u672c\u7684\u306bto_char\u306fSELECT\u3059\u308b\u3068\u304d\u306b\u8868\u793a\u5f62\u5f0f\u3092\u6307\u5b9a<br \/>\n\u30fbto_date \u306f\u3001where\u53e5\u306a\u3069\u306b\u304a\u3044\u3066\u65e5\u4ed8\u3067\u7d5e\u308a\u305f\u3044\u3068\u304d\u306b\u6307\u5b9a<\/p>\n<p>\u4f8b\uff09<br \/>\n<code>select username from dba_users where PASSWORD_CHANGE_DATE &lt; to_date('2020\/07\/07','YYYY\/MM\/DD');<\/code><\/p>\n<p><code>select to_char(created, 'YYYY\/MM\/DD hh24:MI:SS') from dba_users where account_status='OPEN';<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3088\u304f\u5fd8\u308c\u308b\u306e\u3067\u30e1\u30e2 \u30fb\u57fa\u672c\u7684\u306bto_char\u306fSELECT\u3059\u308b\u3068\u304d\u306b\u8868\u793a\u5f62\u5f0f\u3092\u6307\u5b9a \u30fbto_date \u306f\u3001where\u53e5\u306a<\/p>\n<p><a class=\"more-link\" href=\"http:\/\/www.shamonabe.com\/?p=97\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/97"}],"collection":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=97"}],"version-history":[{"count":2,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/97\/revisions"}],"predecessor-version":[{"id":99,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/97\/revisions\/99"}],"wp:attachment":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}