meta data for this page
  •  

F_LASTDAYNEXTMONTH

input/output-compatibility to rFunc (LASTDAYMONTH)

Entrypoint lastdaynextmonth compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
   Output     TIMESTAMP     date of last day of next month as date with time 00:00:00

Syntax

   TestSQL
   SELECT '30.06.2009' AS ISCORRECT, F_LASTDAYNEXTMONTH('08.05.2009 15:00:00') FROM RDB$DATABASE;
   SELECT '31.01.2010' AS ISCORRECT, F_LASTDAYNEXTMONTH('08.12.2009 15:00:00') FROM RDB$DATABASE;