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.