Visual FoxPro

Extract Timestamp from ULID

See more ULID/UUID Examples

Extract the date/time from a ULID.

Important: Chilkat's ULID functionality was introduced in v9.5.0.94.

Visual FoxPro

LOCAL lnSuccess
LOCAL lcUlid
LOCAL loDt
LOCAL lnBLocal

lnSuccess = 0

lcUlid = "01GRH14AA82EY9A7S99YYF2QDY"

loDt = CreateObject('Chilkat.CkDateTime')

* Unix timestamps stored in ULIDs should be UTC...
lnBLocal = 0
* Set the CkDateTime from the timestamp contained in the ULID
lnSuccess = loDt.SetFromUlid(lnBLocal,lcUlid)
IF (lnSuccess = 0) THEN
    ? "ULID was not valid."
    RELEASE loDt
    CANCEL
ENDIF

* You can now get the date/time in any desired format.
* For example:
? "Unix timestamp = " + STR(loDt.GetAsUnixTime(lnBLocal))
? "RFC822 = " + loDt.GetAsRfc822(lnBLocal)
? "Timestamp = " + loDt.GetAsTimestamp(lnBLocal)

* Sample output:

* Unix timestamp = 1675608861
* RFC822 = Sun, 05 Feb 2023 14:54:21 GMT
* Timestamp = 2023-02-05T14:54:21Z

RELEASE loDt