Olivier Mengué wrote:
As said in the original thread, using BETWEEN is a very bad idea.
I just re-read that thread. I think Dave's post <http://www.nntp.perl.org/group/perl.datetime/2009/04/msg7247.html> summarizes the issues quite well.

I suppose he is right and that explicit half-open intervals would be the best way to go. I'm just used to using BETWEEN and as long as I know the resolution of the database column I'm dealing with (in this case, MySQL datetime columns), then I can get away with my sub-par practice.

But this has been an enlightening discussion.
Your 'nowe' method is a very bad idea as is supposes that the DateTime precision is the second.
Actually it _defaults_ to that, but the ->set_eod() method can change the resolution.


Reply via email to