MONTH

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


MONTH (arithmetic_expression)

Description

The MONTH function returns the number of the month (ranging from 1 to 12) of the date passed in the arithmetic_expression.

Example

Supposing that we have the PEOPLE table with a Date_of_Birth field. To find out the month of the date of birth for every person in PEOPLE :

   SELECT MONTH(Date_of_Birth)
     FROM PEOPLE; 

See Also

DAYOFMONTH, MONTHNAME.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next