Help for this page
my $sql1_datos = qq(select contador, cod_entidad_oim, cod_agr, cod_ope +racion from mapcom_portext.TR0685002 where fch_hor_operacion between + to_date(\'$now\','dd-mon-yyyy') and to_date(\'$1hourago\','dd-mon-yy +yy'));
use POSIX 'strftime'; $now = lc strftime("%d/%m/%y %H:%M:%S", localtime);