# Retrieve answerset. while($odbc_session->FetchRow()) { # Stores the hash variable. eval $odbc_session->Data(); } #### while($odbc_session->FetchRow()) { # Stores the hash variable. my %pmsr = $odbc_session->DataHash(); ## push @pmsr, \%pmsr; # Pushes each value in the DWH_PrfMsr column into the @pmsr. push @pmsr, {%pmsr}; # Pushes an anon.hash-ref copy of %pmsr onto @pmsr. } #### my @datetime = ((localtime)[0,1,2,3,4,5]); foreach(@datetime) { if($count == 4) { $_ += 1 } elsif($count == 5) { $_ += 1900 } if(length $_ == 1) { $_ = "0$_"; } $count++; } my($sec,$min,$hour,$day,$month,$year) = @datetime; #### my($sec,$min,$hour,$day,$month,$year) = map {sprintf("%02d",$_)} (localtime)[0..5]; $month++; $year += 1900;