4D v13.4

WEEK

Home

 
4D v13.4
WEEK

WEEK  


 

 

Command WEEWEEK (arithmetic_expression)

The WEEK function returns the week of the year (ranging from 1 to 54) of the date passed in the arithmetic_expression. The week begins on Sunday and January 1st is always in the first week.

Example  

This example returns a number representing the week of the year for each date of birth passed:

SELECT WEEK(Date_of_birth);

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands

 
SEE ALSO 

DAYOFWEEK