This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
Home
4D v20 R7
4D SQL Reference
Functions
DAYOFMONTH

DAYOFMONTH  


 

 

Command DAYOFMONTHDAYOFMONTH (arithmetic_expression)

The DAYOFMONTH function returns a number representing the day of the month (ranging from 1 to 31) 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 day number of the date of birth for every person in PEOPLE:


SELECT DAYOFMONTH(Date_of_Birth)
FROM PEOPLE;



See also 

DAY
DAYNAME
DAYOFWEEK
DAYOFYEAR

Previous page
Next page

 
PROPERTIES 

Product: 4D
Theme: Functions

 
PAGE CONTENTS 
Description
Example
 
HISTORY 

 
ARTICLE USAGE

4D SQL Reference ( 4D v20 R7)