Can't trunc date to current day in Oracle #1155

robertandrewbain opened this Issue Feb 5, 2015 · 0 comments


None yet
2 participants

robertandrewbain commented Feb 5, 2015

In Oracle TRUNC(some_date) will remove the time element from the date. TRUNC(some_date, 'day') however, will return the start of the week, which is what you get if you call SQLExpressions.datetrunc(, someDateTimePath). IMO, this is poor naming on Oracle's part, however I would have expected the SQL to manifest to be TRUNC(some_date, 'dd'), or for DatePart to include further values so that TRUNC(some_date, 'dd') was attainable, or better yet that TRUNC(some_date) with no time component was supported.

@timowest timowest added the bug label Feb 5, 2015

@timowest timowest added this to the 4.0.0 milestone Feb 7, 2015

@timowest timowest added the progress label Feb 7, 2015

@Shredder121 Shredder121 closed this in #1179 Feb 17, 2015

@timowest timowest removed the progress label Mar 13, 2015

@timowest timowest modified the milestones: 3.6.2, 4.0.0 Mar 31, 2015

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment