meta data for this page
  •  

F_DTIME

function from adhoc

Entrypoint dtime compatible with UTF-8

Inputs/Outputs

   Input      TIMESTAMP     date optionally time 
   Output     INTEGER       amount of days between the timestamp and 1899-12-31

Syntax

   Counting starts at 0.
   TestSQL
   SELECT 2 AS ISCORRECT, F_DTIME('03.01.1900') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_DTIME(NULL) FROM RDB$DATABASE;