Re^6: timestamp in perl

[baperl]

thanks, that's a lot of good info. maybe I can ask you another q :-) I am running this query, and it works fine in mySQL, i.e. md contains the right datetime value in mySQL. however, I don't believe mt is getting assigned md's value

my $check_inv_sql = "SELECT MAX(cdt) AS md FROM s_i ORDER BY cdt LIMIT
+ 1";

$sth=$dbh->prepare($s_query) or die $dbh->errstr;

$sth->execute;

my $mt;

if (my $hash_ref = $sth->fetchrow_hashref)
{
 $mt = $hash_ref->{'md'};
print "$mt\n";#this returns below error
}

and the error it generates is

Use of uninitialized value $mt in concatenation (.) or string at Sb.pl
+ line 56.

It seems to me that I am not assigning md correctly to $mt. If that is indeed the case, how do I correct the above code....thx!

[Util]

It would help to know whether the key {'md'} is missing from the hash, or the key exists but the value undefined. Also, what else is in the hash?

What output do you get with this change?

# ... same code as above
use Data::Dumper; $Data::Dumper::Useqq = 1;
if ( my $hash_ref = $sth->fetchrow_hashref ) {
    print Dumper $hash_ref;
}

[baperl]

my apologies....I was preparing and executing the wrong query as you'll notice in my code....the marvels of copy and paste. your code on the Data::Dumper is helpful, so thanks for that....it'll save me trouble in the future :-)