Examine this PeopleCode snippet:
&SQL = CreateSQL("Select %EffDtCheck(EFFDT) from %Table(PSU_INSTR_TBL)");
Select the correct option.
A. The statement is valid.
B. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %DateIn(EFFDT) from %Table(PSU_INSTR_TBL)");
C. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %DateOut(EFFDT) from %Table(PSU_INSTR_TBL)");
D. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %CurrDate(EFFDT) from %Table(PSU_INSTR_TBL)");
E. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %Date(EFFDT) from %Table(PSU_INSTR_TBL)");
F. The statement is not valid. The correct syntax is:
&SQL = CreateSQL("Select %Current(EFFDT) from %Table(PSU_INSTR_TBL)");