{"id":2276,"date":"2014-09-23T12:58:59","date_gmt":"2014-09-23T10:58:59","guid":{"rendered":"http:\/\/www.nyamsprod.com\/blog\/?p=2276"},"modified":"2014-09-23T14:07:05","modified_gmt":"2014-09-23T12:07:05","slug":"specifying-the-endpoints-of-a-time-range","status":"publish","type":"post","link":"https:\/\/nyamsprod.com\/blog\/specifying-the-endpoints-of-a-time-range\/","title":{"rendered":"Specifying the endpoints of a time range"},"content":{"rendered":"
\n

Attention:<\/strong> Les informations de ce billet sont susceptibles d'être obsolètes car vieux de plus 2 ans.<\/p>\n

Warning: <\/strong> The information you are reading may be obsolete, this post was published more than 2 years ago.<\/p>\n<\/div>

In PHP we hate re-inventing the wheel so when I stumble on Mathias Verraes post about a ReportingPeriod<\/a> class it just reminded me how often I came across the same problem over and over again in my daily life as a developer. So to resolve this issue, hopefully, once for all, I decided to implement an Immutable Value Object class which will deal with time range. So here I present you Bakame\\Period<\/code><\/a><\/p>\n

If you look at the Github source code<\/a>, you’ll see that the class is very simple and only requires PHP 5.3+ . The only problem that I run into when creating this class was specifying its endpoints values.<\/p>\n

To understand the solution that I implemented I’ll take two examples:<\/p>\n

First let’s assume you are booking your holidays so you need to tell your boss when you will be back at work. You have at least two options to say it:<\/p>\n

I’ll take my holiday from January 1st to January 7th included.<\/p><\/blockquote>\n

Or<\/p>\n

I’ll take my holiday on January 1st and I’ll be back at work on the 8th of January.<\/p><\/blockquote>\n

Both sentences convey the same information but note that in the first one you had to add the included<\/strong> <\/em>word in your statement to remove any ambiguity. Otherwise, your boss would have think that you would be back at work on the 7th of January. Telling your boss the real end of your holiday is not always a smart move \ud83d\ude42 .<\/p>\n

Now let’s look at another situation that will talk more to us developers (..because developers never take holidays). Look at the following queries.<\/p>\n

$query1 = \"SELECT COUNT(*) FROM users WHERE create_at>= '201-06-05 00:00:00' AND create_at <= '2014-06-05 23:59:59'\";\r\n$query2 = \"SELECT COUNT(*) FROM users WHERE create_at>= '201-06-05 00:00:00' AND create_at < '2014-06-06 00:00:00'\";<\/code><\/pre>\n