meta data for this page
  •  

F_UUID1TIMESTAMP

function from adhoc

Entrypoint uuid1timestamp compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid UUID version 1
   Output     TIMESTAMP        timestamp of the creating date and time of the UUID version 1

Syntax

   Reports the timestamp from the UUID when the UUID was created. If the timestamp isn’t real, the function reports 31.12.1899 00:00:00  (Time = 0 - starttime of the internal InterBase/FireBird time) instead of FireBird 2.0, it returns <null> if it is declaired.  
   TestSQL (to use with TestISO.GDB)
   If you take an compressed UUID for input instead of a normal UUID:
   SELECT UUIDTESTID, F_UUIDVERSION(UUID), ART, NULL AS ISCORRECT, F_UUID1TIMESTAMP(UUIDCOMPR) FROM UUIDTEST ORDER BY 1;
   If you take a normal UUID for input (right):
   SELECT UUIDTESTID, F_UUIDVERSION(UUID), ART, ZEITSTEMPEL AS ISCORRECT, F_UUID1TIMESTAMP(UUID) FROM UUIDTEST ORDER BY 1;
   SELECT NULL AS ISCORRECT, F_UUID1TIMESTAMP(NULL) FROM RDB$DATABASE;