Modify
tinita's code as follows
if ($row->{start_date} ne $last_date && (split/:/,$row->start_time)[0]
+ > 9) {
update: Oops. That will output incorrect results if all entries for a day are
from before 9:00. Make a hash keyed with unix timestamps of each date, push each entry
onto an array for the appropriate day:
use Time::Local;
...
for my $row (@rows) {
my @l = reverse split /-/, $row->{start_date};
$l[1]--; # months range is 0..11
my $key = timelocal(0,0,0,@l);
my $line = join("\t", $row->{id_number}, $row->{start_time}); # wh
+atever formatting
if(split/:/,$row->start_time)[0] > 9) {
push @{$hash{$key-86400}}, $line;
} else {
push @{$hash{$key}}, $line;
}
}
foreach my $key (sort %hash) {
my @l = (localtime $key)[5,4,3];
$l[1]++; # month...
print join('-', @l), "\n";
print $_,"\n" for @{$hash{$key}};
}
--shmem
_($_=" "x(1<<5)."?\n".q·/)Oo. G°\ /
/\_¯/(q /
---------------------------- \__(m.====·.(_("always off the crowd"))."·
");sub _{s./.($e="'Itrs `mnsgdq Gdbj O`qkdq")=~y/"-y/#-z/;$e.e && print}
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.