my $dt = DateTime->now( time_zone => "America/New_York" ); my $mydatarow = $schema->resultset( 'DataTable' )->search({ START_DATE => { '>=' => $dt }, END_DATE => { '=<' => $dt }})->single;