MySQL DATE_FORMAT()

[Deleted]

Got a problem with query output using perl

my $query = "SELECT id, handle, DATE_FORMAT(insert_date, '%l:%i:%S %p') FROM session ORDER BY insert_date";
my $sth = $dbh->prepare($query);
$sth->execute;
my $data = $sth->fetchrow_hashref;

print "$data->{insert_date}";

The issue is that when I query the results as a hashref or arrayref_all the 'field name (insert_date)' returns a undef value.

Any suggestions?

http://unixjunky.com

 

[r937]

try assigning the column an alias name in the sql, then using that name in your script

SELECT id
     , handle
     , DATE_FORMAT(insert_date,'%l:%i:%S %p') 
         [b]as display_insert_date[/b]
  FROM session 
ORDER BY insert_date

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)