in reply to Re^3: timestamp in perl
in thread timestamp in perl

yes indeed, you're right...that was the mistake I was making...thx!

Replies are listed 'Best First'.
Re^5: timestamp in perl
by Anonymous Monk on Sep 24, 2011 at 19:23 UTC
[reply]
      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
}

      [download]
      and the error it generates is 
      Use of uninitialized value $mt in concatenation (.) or string at Sb.pl
+ line 56.

      [download]
      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!
[reply]
[d/l]
[select]

        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;
}

        [download]

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom