tag:blogger.com,1999:blog-4818542164384221282.post8188072775799277992..comments2024-03-25T17:53:49.828+08:00Comments on Grassroots Oracle: Remember date contains timeScott Wesleyhttp://www.blogger.com/profile/18106937181788036683noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4818542164384221282.post-39193597442589339312012-05-09T22:08:11.117+08:002012-05-09T22:08:11.117+08:00And I've cleaned up the post - for some reason...And I've cleaned up the post - for some reason there was start/stop tags throughout the code...?Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-4818542164384221282.post-49585770083828878352012-05-09T22:07:32.950+08:002012-05-09T22:07:32.950+08:00As long is it works ok for you - there always seem...As long is it works ok for you - there always seems to be a zillion way to do things in Oracle ;-)Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-4818542164384221282.post-1718889624459781052012-05-09T16:37:45.336+08:002012-05-09T16:37:45.336+08:00For date fields which regularly contain time, I...For date fields which regularly contain time, I've considered creating a function-based-index on trunc(column), but ultimately always fall back on "between trunc(mydate) and trunc(mydate)+86399/86400".Kris Scoruphttps://www.blogger.com/profile/12853095309827550850noreply@blogger.com