XLODBC 1 DSN=xa21;UID=XAJTDB/N3ptunE1!!;DBQ=XA21;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;MLD=0;ODA=F;STE=F;TSZ=8192;AST=FLOAT;LPS=8192; SELECT(UNIT1_MW.UTCTIME+5.5/24) TIME, UNIT1_MW.VALUE UNIT1_MW, UNIT2_MW.VALUE UNIT2_MW FROM XAJTDB.TPCL_MW UNIT1_MW, XAJTDB.TPCL_MW UNIT2_MW WHERE (UNIT1_MW.POINTNUMBER=19416 AND UNIT2_MW.POINTNUMBER=19454) AND ((UNIT1_MW.UTCTIME>={ts '2025-01-01 00:30:00'}) And UNIT1_MW.UTCTIME<={ts '2025-01-02 00:30:00'}) And ((UNIT2_MW.UTCTIME>={ts '2025-01-01 00:30:00'}) And UNIT2_MW.UTCTIME<={ts '2025-01-02 00:30:00'})ORDER BY UNIT1_MW.UTCTIME

POINTNUMBER UTCTIME VALUE