DAYOFMONTH

 

The function DAYOFMONTH returns an integer in the range of 1 to 31. This integer represent the count of days since beginning of the month.

SQL Syntax:
 
   DAYOFMONTH( date )
Date:
 
  Any date expression.
Escape Syntax:
 
  {fn DAYOFMONTH( date )}
Return Type:
 
  INT
     

Examples:

  • SELECT DAYOFMONTH({d '2006-01-01'}), {fn dayofmonth({d '2004-12-31'})}

    Returns: 1, 31

see also:
SQL Date Time Functions
DAYOFWEEK
DAYOFYEAR


100% pure Java DBMS
Mirror Site