Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > Date And Time Functions (XDB Mode) > DAYOFYEAR

DAYOFYEAR

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

The DAYOFYEAR function give the number of days (1-366) since the beginning of the year for specified date (a.k.a. Julian date). The format appears below:

DAYOFYEAR(date)

For example:

DAYOFYEAR(06/21/1991) = 173
Parent topic: Date And Time Functions (XDB Mode)
Previous Topic Next topic Print topic