- 2023-08-2355555
selecta.c_port_code,a.c_port_name,to_char(A1.D_ASTSTAT,'yyyy-mm-dd')D_ASTSTAT,CASEWHENA.C_DAT_CODEin('ASS_FOF','ASS_QDII')THENNVL(A11.DWJZ,A111.DWJZ)ELSEA1.DWJZENDDWJZ,CASEWHENA.C_DAT
- 2023-08-23select a.c_port_code,
selecta.c_port_code,a.c_port_name,to_char(A1.D_ASTSTAT,'yyyy-mm-dd')D_ASTSTAT,CASEWHENA.C_DAT_CODEin('ASS_FOF','ASS_QDII')THENNVL(A11.DWJZ,A111.DWJZ)ELSEA1.DWJZENDDWJZ,CASEWHENA.C_DAT
- 2023-08-23SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME DWJZ
SELECTa.c_port_code,a.d_aststat,a.C_KM_NAMEDWJZFROMt_r_fr_aststatawhere(A.C_PORT_CODE='SGU520')anda.d_aststat=GETDAY_HDAY('CN',LAST_DAY(date'2023-07-01')+1,-1,'W