meta data for this page
  •  

F_UUID1COMPRTIMESTAMP

function from adhoc

Entrypoint uuid1comprtimestamp compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid compressed UUID version 1
   Output     TIMESTAMP        timestamp of the creating date and time of the compressed 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 a normal UUID for input instead of a compressed UUID:
   SELECT UUIDTESTID, F_UUIDVERSION(UUID), ART, NULL AS ISCORRECT,
   F_UUID1COMPRTIMESTAMP(UUID) FROM UUIDTEST ORDER BY 1;
   If you take a compressed UUID for input (right):
   SELECT UUIDTESTID, F_UUIDVERSION(UUID), ART, ZEITSTEMPEL AS ISCORRECT,
   F_UUID1COMPRTIMESTAMP(UUIDCOMPR) FROM UUIDTEST ORDER BY 1;
   SELECT NULL AS ISCORRECT, F_UUID1COMPRTIMESTAMP(NULL) FROM RDB$DATABASE;