meta data for this page
  •  

F_FIRSTDAYQUARTER

function from adhoc

Entrypoint firstdayquarter compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time
   Output     TIMESTAMP     date of 1st day of quarter as date with time 00:00:00

Syntax

   TestSQL
   SELECT '01.07.2008' AS ISCORRECT, F_FIRSTDAYQUARTER('06.09.2008 15:00:00') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_FIRSTDAYQUARTER(NULL) FROM RDB$DATABASE;