meta data for this page
  •  

F_EQUALDATE

compatibility to FreeUDFLib AvERP, GrUDF

Entrypoint equaldate compatible with UTF-8

Inputs/Outputs

   Input     TIMESTAMP     date optionally time 1
             TIMESTAMP     date optionally time 2
   Output    INTEGER       1 = date is equal, 0 = date is not equal

Syntax

   Tested only on date (time could be entered but never used)
   TestSQL
   SELECT 1 AS ISCORRECT, F_EQUALDATE('20.02.2004 10:00:00', '20.02.2004 11:00:00') FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_EQUALDATE('20.02.2004 10:00:00', '21.02.2004 11:00:00') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_EQUALDATE(NULL, NULL) FROM RDB$DATABASE;