Advertisement
ma39isy

Untitled

Mar 14th, 2024
1,318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     A.*,
  3.     TO_CHAR(A.ACADEMICCOUNCILDATE, 'dd-mm-yyyy') AS COUNCILDATE,
  4.     TO_CHAR(A.ACADEMICCOUNCILDATE, 'dd/mm/yyyy') AS COUNCILDATE2
  5. FROM
  6.     ACADEMICSTATUS A
  7. WHERE
  8.     STUDENTID = '1201170353'
  9.     AND ACADEMICCOUNCILDATE IS NOT NULL
  10.     AND GRADE = '4';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement