meta data for this page
  •  

F_LASTDAYNEXTQUARTER

function from adhoc

Entrypoint lastdaynextquarter compatible with UTF-8

Inputs/Outputs

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

Syntax

   TestSQL
   SELECT '30.09.2009' AS ISCORRECT, F_LASTDAYNEXTQUARTER('08.05.2009 15:00:00') FROM RDB$DATABASE;
   SELECT '31.03.2010' AS ISCORRECT, F_LASTDAYNEXTQUARTER('08.11.2009 15:00:00') FROM RDB$DATABASE;