Select Code to Download

Sql::Stash->set_sql('last_downloadevent', q(select max (ymdhms) from r
+ktrack.downloadevent),'RKG',0);

...
<% $last_downloadevent %>
...
$sth->finish;
...
</%init>

Sql::Stash->set_sql('last_downloadevent', q(select concat(max(ymdhms) 
+,'-', now()) from rktrack.downloadevent where ?>0),'RKG',0);

select max(ymdhms) from rktrack.downloadevent

perl -MSql::Stash -e "my $ss=Sql::Stash->new; my $sth=$ss->sql_last_do
+wnloadevent; $sth->execute; print $sth->fetch"