{"id":6,"date":"2005-02-27T22:01:47","date_gmt":"2005-02-28T02:01:47","guid":{"rendered":"http:\/\/hoogervorst.dyndns.org\/~arthur\/wordpress\/?p=6"},"modified":"2005-02-27T22:09:38","modified_gmt":"2005-02-28T02:09:38","slug":"databeast-and-time","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=6","title":{"rendered":"Databeast and time"},"content":{"rendered":"<p><span class=\"dropcap\">E<\/span>arlier this week, I thought I had made a crucial mistake when I was testing a couple of new and existing reports on my Debian database server (at home). For some kind of reason, firing up a query that returns a selection between two dates didn&#8217;t return the results I wanted to see (example):\n<\/p>\n<p><code><br \/>\nSELECT * from atable<br \/>\nWHERE date_in >= '01\/01\/05'<br \/>\nAND date_in < = '01\/31\/05';\n<\/code><br \/>\n<\/code><\/p>\n<p>Under all normal circumstances this query should return all the rows that fall in between those days, <em>including<\/em> the 31st of January.  My home server didn&#8217;t.\n<\/p>\n<p>It ended up to be a timezone configuration error on my server: My server was set to EST, while AST would have been more appropriate.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Earlier this week, I thought I had made a crucial mistake when I was testing a couple of new and existing reports on my Debian database server (at home). For some kind of reason, firing up a query that returns &hellip; <a href=\"http:\/\/www.hoogervorst.ca\/arthur\/?p=6\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[15],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/6"}],"collection":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/6\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}