my $dbh = DBI->connect($dsn, $userid, $password, { RaiseError => 1 }) or die $DBI::errstr; my $query = "SELECT * FROM logs_column WHERE logged_in > NOW()::timestamp - interval '24hour'"; my $sth = $dbh->prepare($query); $sth->execute(); while (my @row = $sth->fetchrow_array) { print "@row\n"; }