{"id":35,"date":"2003-04-28T11:34:11","date_gmt":"2003-04-28T01:34:11","guid":{"rendered":"http:\/\/www.thunderguy.com\/plusplus\/20050422\/oracle-silently-truncates-dates\/"},"modified":"2005-08-02T10:34:25","modified_gmt":"2005-08-02T00:34:25","slug":"oracle-silently-truncates-dates","status":"publish","type":"post","link":"https:\/\/thunderguy.com\/semicolon\/2003\/04\/28\/oracle-silently-truncates-dates\/","title":{"rendered":"Oracle silently truncates dates"},"content":{"rendered":"<p>According to the documentation, the Oracle <code>DATE<\/code> type does not store fractions of a second. So if you store a date\/time value including fractions of a second and read it back, you&#8217;ll get back a slightly different date\/time. This will cause exact date matching code in your appplication to fail.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>According to the documentation, the Oracle DATE type does not store fractions of a second. So if you store a date\/time value including fractions of a second and read it back, you&#8217;ll get back a slightly different date\/time. This will cause exact date matching code in your appplication to fail.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[5],"class_list":["post-35","post","type-post","status-publish","format-standard","hentry","tag-sql"],"_links":{"self":[{"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/posts\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/comments?post=35"}],"version-history":[{"count":0,"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"wp:attachment":[{"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thunderguy.com\/semicolon\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}