I noticed the 2 fields in the subject, but didn't actually recoginize them(I've been using ofbiz for a *long* time). I did a big of digging, and noticed that those fields were added to the model in 2006-05-04(1), and were first utilized when anonymous checkout was added 2006-11-28(2). There has been no real use of the 2 fields since then.
Why do they have to exist? Why can't DATE_TRUNC or some other sql function be used? Or normal Timestamp manipulation on fromDate/thruDate? 1: http://svn.ofbiz.org/svn/ofbiz/trunk@7513 2: https://svn.apache.org/repos/asf/incubator/ofbiz/trunk@479879