4D v13.4

QUARTER

Home

 
4D v13.4
QUARTER

QUARTER  


 

 

Command QUARTERQUARTER (arithmetic_expression)

The QUARTER function returns the quarter of the year (ranging from 1 to 4) in which the date passed in the arithmetic_expression occurs.

Example  

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

SELECT QUARTER(Date_of_Birth)
FROM PEOPLE;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

MONTH
YEAR