PowerBuilder

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.

PowerBuilder

integer li_rc
integer li_Success
string ls_Ulid
oleobject loo_Dt
integer li_BLocal

li_Success = 0

ls_Ulid = "01GRH14AA82EY9A7S99YYF2QDY"

loo_Dt = create oleobject
li_rc = loo_Dt.ConnectToNewObject("Chilkat.CkDateTime")
if li_rc < 0 then
    destroy loo_Dt
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// Unix timestamps stored in ULIDs should be UTC...
li_BLocal = 0
// Set the CkDateTime from the timestamp contained in the ULID
li_Success = loo_Dt.SetFromUlid(li_BLocal,ls_Ulid)
if li_Success = 0 then
    Write-Debug "ULID was not valid."
    destroy loo_Dt
    return
end if

// You can now get the date/time in any desired format.
// For example:
Write-Debug "Unix timestamp = " + string(loo_Dt.GetAsUnixTime(li_BLocal))
Write-Debug "RFC822 = " + loo_Dt.GetAsRfc822(li_BLocal)
Write-Debug "Timestamp = " + loo_Dt.GetAsTimestamp(li_BLocal)

// Sample output:

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


destroy loo_Dt