meta data for this page
  •  

F_ZEITDIFFERENZ

compatibility to FreeUDFLib AvERP, GrUDF

Entrypoint zeitdifferenz compatible with UTF-8

Inputs/Outputs

   Input     TIMESTAMP      date optionally time 1
             TIMESTAMP      date optionally time 2
             CSTRING(1)     type of output
                                      t = time between in days
                                      h = time between in hours
                                      m = time between in minutes
                                      s = time between in seconds
                                      all other values return 0
   Output    DOUBLE          time between date 1 and 2 as floatingpoint of the chosen parameter 3

Syntax

   TestSQL
   SELECT 1.000 AS ISCORRECT, F_ZEITDIFFERENZ('02.10.2005 15:00:00', '01.10.2005 15:00:00', 't') FROM RDB$DATABASE;
   SELECT 1.125 AS ISCORRECT, F_ZEITDIFFERENZ('02.10.2005 18:00:00', '01.10.2005 15:00:00', 't') FROM RDB$DATABASE;
   SELECT 26.500 AS ISCORRECT, F_ZEITDIFFERENZ('02.10.2005 18:00:00', '01.10.2005 15:30:00', 'h') FROM RDB$DATABASE;
   SELECT 1589.500 AS ISCORRECT, F_ZEITDIFFERENZ('02.10.2005 18:00:00', '01.10.2005 15:30:30', 'm') FROM RDB$DATABASE;
   SELECT 95370.000 AS ISCORRECT, F_ZEITDIFFERENZ('02.10.2005 18:00:00', '01.10.2005 15:30:30', 's') FROM RDB$DATABASE;
   SELECT 0.000 AS ISCORRECT, F_ZEITDIFFERENZ('02.10.2005 18:00:00', '01.10.2005 15:30:30', 'x') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ZEITDIFFERENZ(NULL, NULL, NULL) FROM RDB$DATABASE;