<< F_DAYOFYEAR F_EXTRACTYEARDAY | IBExpert UDF Functions | F_DAYOFWEEK F_EXTRACTWEEKDAY F_DOW >>

F_DAYOFMONTH

substitutable with EXTRACT(DAY FROM ...)

• compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF input/output-compatibility to rFunc (EXTRACTDAY)
• Compatible with UTF-8
• Input TIMESTAMP date optionally time
• Output INTEGER

day of the month

Counting starts with 1

Example

 select 23 as ISCORRECT, F_DAYOFMONTH('23.08.2018')
 from RDB$DATABASE
 union
 select null as ISCORRECT, F_DAYOFMONTH(null)
 from RDB$DATABASE;

Expected results:

    ISCORRECT
 ============ ============
       <null>       <null>
           23           23

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