DB2 graphic  QMF Version 8

Isolating the day, month, or year portion of a date

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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004