... my $sql = "select id, account_number, CONVERT(VARCHAR(10),date,101) as date from my_table where id <>'' order by date desc"; my @columns = qw( id account_number box ); my $results = $self->_all_data($sql, \@columns); ...