The DAY function returns the day part of a value. The argument must be a date, timestamp, or a decimal number that is interpreted as a duration of years, months, or days. (For a complete description of durations, see Using durations to represent date/time intervals.) The following SQL statement produces a report showing on which day of the month an interview occurs:
SELECT TEMPID, DAY(INTDATE) FROM Q.INTERVIEW WHERE MANAGER = 270
This report shows that the interviews take place on the fifth day of the month:
DAY OF TEMPID MONTH ------ --------- 400 5 470 5
The MONTH function returns the month part of a value. The argument must be a date, timestamp, or a decimal number that is interpreted as a duration of years, months, or days. The following SQL statement produces a report showing on which month of the year an interview occurred:
SELECT MANAGER, DISP, MONTH(INTDATE) FROM Q.INTERVIEW
This report shows the months in which certain managers interviewed prospective employees and the disposition of each interview.
MANAGER DISP MONTH ------- ------ ----------- 270 NOHIRE 2 10 HIRE 2 140 HIRE 4 290 NOHIRE 4 160 HIRE 3 50 HIRE 9 100 HIRE 10 270 HIRE 2 160 NOHIRE 3 140 NOHIRE 9
The YEAR function returns the year part of a value. YEAR works like DAY and MONTH. The argument must be a date, timestamp, or a decimal number that is interpreted as a duration of years, months, or days. When you run the following SQL statement:
SELECT PROJNO, YEAR(ENDD) FROM Q.PROJECT WHERE PRODNUM = 190
QMF produces this report:
YEAR OF PROJNO COMPLETION ------ ----------- 1404 1999 1410 2000
This report shows the year of project end dates for a given product. It disregards the day and month.