Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re^3: Check if Date interval contains Hour X

by alexm (Chaplain)
on Jul 23, 2009 at 20:08 UTC ( [id://782777]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Check if Date interval contains Hour X
in thread Check if Date interval contains Hour X

The very first thing that came to my mind after reading the OP was the method DateTime::Span::contains. However, yours is the right approach since that method only works for sets that are fully inside, as the manual says.

Thanks!

Replies are listed 'Best First'.
Re^4: Check if Date interval contains Hour X
by ikegami (Patriarch) on Jul 23, 2009 at 20:26 UTC
    contains wouldn't work, but intersects would
    ...| 20 | 21 | 22 | 23 | 00 | 01 | 02 | 03 |... (------------) log (----] hour (--) intersection

      You're right again, I just realized a bit later so I've been playing with intersects:

      sub hour_in_range { my ($dt_s, $dt_e, @hours) = @_; my $dt_span = DateTime::Span->from_datetimes( start => $dt_s, end => $dt_e ); for my $hour (@hours) { my $dt = $dt_s->clone() ->truncate( to => 'day' ) ->add( hours => $hour ); $dt->add( days => 1 ) if $dt < $dt_s; my $hour_span = DateTime::Span->from_datetimes( start => $dt, end => $dt ); return 1 if $dt_span->intersects($hour_span); } return 0; }

      It's not as simple and efficient as your approach, but it shows how to use span intersection.

      OTOH, I misunderstood the OP and was thinking that @hours = (1,11) was an interval (1am to 11am), not a list of hours to match.

        my $hour_span = DateTime::Span->from_datetimes( start => $dt, end => $dt );

        should be

        my $hour_span = DateTime::Span->from_datetimes( start => $dt, before => $dt->clone()->add( hours => 1 ), );

        or the more readable

        my $hour_span = DateTime::Span->new( start => $dt, hours => 1, );

        Update: No, neither fix help. They were suppose to make the following match:

        2010-10-10 01:59:59|2010-10-10 01:59:59|blablalblabla

        You need

        sub hour_in_range { my ($dt_s, $dt_e, @hours) = @_; my $dt_span = DateTime::Span->from_datetimes( start => $dt_s, end => $dt_e ); for my $hour (@hours) { my $dt = $dt_s->clone() ->truncate( to => 'day' ) ->add( hours => $hour ); my $dt_tomorrow = $dt->clone()->add( days => 1 ); my $hour_span = DateTime::Span->new( start => $dt, hours => 1 )->union( DateTime::Span->new( start => $dt_tomorrow, hours => 1 )); return 1 if $dt_span->intersects($hour_span); } return 0; }

        And there you go, the four DateTimes per hour I mentioned earlier.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://782777]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (2)
As of 2024-04-20 03:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found