<< F_DAYOFWEEK F_EXTRACTWEEKDAY F_DOW | IBExpert UDF Functions | F_LASTDAY >>

F_DAYSOFMONTH

• function from adhoc input/output-compatibility to rFunc (DAYPERMONTH)
• Compatible with UTF-8
• Input INTEGER month INTEGER year
• Output INTEGER amount of days (last day) in the month of the year

Counting starts with 1

Example

 SELECT 29 AS ISCORRECT, F_DAYSOFMONTH(2, 2016) FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_DAYSOFMONTH
 ============ =============
           29            29

Example

 SELECT NULL AS ISCORRECT, F_DAYSOFMONTH(NULL, NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_DAYSOFMONTH
 ========= =============
 <null>           <null>

back to top of page
<< F_DAYOFWEEK F_EXTRACTWEEKDAY F_DOW | IBExpert UDF Functions | F_LASTDAY >>