Suppose you want to know the month and day of interview for all applicants interviewed by manager 140, and you want the result in USA format. When you run this query:
SELECT SUBSTR((CHAR(INTDATE, USA)),1,5) FROM Q.INTERVIEW WHERE MANAGER = 140
QMF produces this report:
+--------------------------------------------------------------------------------+ |DATE | |---------- | |04/07 | |09/30 | +--------------------------------------------------------------------------------+