Select Code to Download

        my $tasks_to_do = $self->search(
                        {
...
                        }
        );

BEGIN {
        $ENV{TZ} = 'Australia/Sydney';
}

$schema->storage->dbh_do(sub {"SET TIMEZONE='Australia/Sydney'"} );

sessions=> SET TIMEZONE='UTC';
SET
sessions=> select * from mytable where scheduled_run_time <= NOW() and
+ status = 'pending';

sessions=> SET TIMEZONE='Australia/Sydney';
SET
sessions=> select * from mytable where scheduled_run_time <= NOW() and
+ status = 'pending';