{"id":2458,"date":"2012-08-22T14:10:49","date_gmt":"2012-08-22T19:10:49","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=2458"},"modified":"2012-08-23T05:01:39","modified_gmt":"2012-08-23T10:01:39","slug":"timestamp-in-gvsql_bind_capture","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2012\/08\/22\/timestamp-in-gvsql_bind_capture\/","title":{"rendered":"TIMESTAMP in GV$SQL_BIND_CAPTURE"},"content":{"rendered":"<p>This has been an issue since at least 10.2.0.3, and appears to still be the case in 11.2.0.3, almost five years later.<\/p>\n<p>A TIMESTAMP datatype in GV$SQL_BIND_CAPTURE is not printed.  Fortunately, the following works.<\/p>\n<pre lang=\"sql\" line=\"1\">\r\nselect anydata.accesstimestamp(value_anydata) from v$sql_bind_capture where sql_id='&your_sql_id';\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This has been an issue since at least 10.2.0.3, and appears to still be the case in 11.2.0.3, almost five years later. A TIMESTAMP datatype in GV$SQL_BIND_CAPTURE is not printed. Fortunately, the following works. select anydata.accesstimestamp(value_anydata) from v$sql_bind_capture where sql_id=&#8217;&#038;your_sql_id&#8217;;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2012\/08\/22\/timestamp-in-gvsql_bind_capture\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2458"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=2458"}],"version-history":[{"count":6,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2458\/revisions"}],"predecessor-version":[{"id":2465,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/2458\/revisions\/2465"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=2458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=2458"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=2458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}