my $tasks_to_do = $self->search(
                        {
                                -and => [ scheduled_run_time => {  '<=', 'NOW()'}, status => 'pending'  ]
                        }
        );


##</code><code>##

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


##</code><code>##

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

##</code><code>##

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

##</code><code>##

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