>SELECT Hmilogdf.MODULO, Hmilogdf.PROGLO,; > {fn substring(usualo,1,9)} AS cliente,; > {fn substring(usualo,10,12)} AS usuario, Hmilogdf.FECHLO,; > eval("{^" +transform(Hmilogdf.FECHLO, "@R 9999/99/99")+ "}") as fecha_conexion,; > Hmilogdf.HORALO, Hmilogdf.TILOLO, Hmilogdf.NRSELO, Hmilogdf.VRENT1,; > Hmilogdf.VRENT2, Hmilogdf.VRENT3, Hmilogdf.VRENT4, Hmilogdf.VRENT5,; > Hmilogdf.VRENT6, Hmilogdf.VRENT7, Hmilogdf.VRENT8, Hmilogdf.VRENT9,; > Hmilogdf.VRENTA, Hmilogdf.VRENTB, Hmilogdf.VRENTC, Hmilogdf.VRENTD,; > Hmilogdf.VRENTE, Hmilogdf.FECHAD; > FROM CGIPYT.HMILOGDF Hmilogdf; > WHERE Hmilogdf.TILOLO = 'CNT'; > AND Hmilogdf.FECHLO BETWEEN ?desde AND ?hasta >>