meta data for this page
  •  

F_ENCODEDATE

compatibility to GrUDF

Entrypoint encodedate compatible with UTF-8

F_ENCODEDATENULL

function from adhoc

Entrypoint encodedatenull compatible with UTF-8

Inputs/Outputs

   Input     INTEGER     year
             INTEGER     month
             INTEGER     day
   Output    DATE        date built from parameters

Syntax

   F_ENCODEDATENULL is able to return NULL
   TestSQL
   SELECT '20.02.2004' AS ISCORRECT, F_ENCODEDATE(2004, 2, 20) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ENCODEDATENULL(NULL, NULL, NULL) FROM RDB$DATABASE;