meta data for this page
  •  

F_FIRSTDAYMONTH

input/output-compatibility to rFunc (FIRSTDAYMONTH)

Entrypoint firstdaymonth compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
   Output     TIMESTAMP     Date with 1st day of the month as date with time 00:00:00

Syntax

   TestSQL
   SELECT '01.01.2007 00:00:00' AS ISCORRECT, F_FIRSTDAYMONTH('03.01.2007 15:00:00') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_FIRSTDAYMONTH(NULL) FROM RDB$DATABASE;