Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Date And Time Functions (XDB Mode) > MONTH

MONTH

ANSI DB2 SQL/DS XDB
  X   X

This function (also XMONTH) extracts the month from a date or timestamp. The format appears below:

MONTH(date-expr)

For example, a query lists the quantity of parts ordered in January:

SELECT p_no, SUM(quantity)
  FROM orders
  WHERE MONTH(o_date) = 1
  GROUP BY p_no
Parent topic: Date And Time Functions (XDB Mode)
Previous Topic Next topic Print topic