DAYOFYEAR

 

The function DAYOFYEAR returns an integer in the range of 1 to 366. This integer represent the count of days since beginning of the year.

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

Examples:

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

    Returns: 1, 366

see also:
SQL Date Time Functions
DAYOFWEEK


100% pure Java DBMS
Mirror Site