meta data for this page
  •  

F_YEAR

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

input/output-compatibility to rFunc (EXTRACTYEAR)

Entrypoint year compatible with UTF-8

F_YEAROFYEAR

(don't use)

compatibility to FreeUDFLibC

Entrypoint yearofyear compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time 
   Output     INTEGER       year of the timestamp

Syntax

   F_YEAR counts with USA-Norm: week starting with Sunday, week 1 contains 1st January.
   F_YEAROFYEAR counts wrong (not ISO): week starts with Sunday, week 1 starts with Sunday to Wednesday
   TestSQL
   SELECT 2004 AS ISCORRECT, F_YEAR(' 22.08.2004 14:38:12') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_YEAR(NULL) FROM RDB$DATABASE;
   SELECT 2004 AS ISCORRECT, F_YEAROFYEAR(' 22.08.2004 14:38:12') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_YEAROFYEAR(NULL) FROM RDB$DATABASE;