meta data for this page
  •  

F_EQUALDATETIME

compatibility to FreeUDFLib AvERP, GrUDF

input/output-compatibility to rFunc (DTEQUAL)

Entrypoint equaldatetime compatible with UTF-8

Inputs/Outputs

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

Syntax

   Tested on date and time
   TestSQL
   SELECT 1 AS ISCORRECT, F_EQUALDATETIME('20.02.2004 10:00:00', '20.02.2004 10:00:00') FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_EQUALDATETIME('20.02.2004 10:00:00', '20.02.2004 11:00:00') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_EQUALDATETIME(NULL, NULL) FROM RDB$DATABASE;