(PowerBuilder) How to Parse a TimeStamp (such as 2016-11-11T14:32:17.0908971Z)

Timestamps are frequently used in REST API responses. This example demonstrates how to parse a timestamp string to get at the date/time components in the local timezone or in the GMT/UTC timezone.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
string ls_StrTimestamp
oleobject loo_DateTime
integer li_BLocalTimezone
oleobject loo_Dt

// Let's say we have a timestamp string such as 2016-11-11T14:32:17.0908971Z
ls_StrTimestamp = "2016-11-11T14:32:17.0908971Z"

loo_DateTime = create oleobject
// Use "Chilkat_9_5_0.CkDateTime" for versions of Chilkat < 10.0.0
li_rc = loo_DateTime.ConnectToNewObject("Chilkat.CkDateTime")
if li_rc < 0 then
    destroy loo_DateTime
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_DateTime.SetFromTimestamp(ls_StrTimestamp)

// Get a DtObj in the local timezone.
li_BLocalTimezone = 1
loo_Dt = loo_DateTime.GetDtObj(li_BLocalTimezone)

// Get the individual date/time components
Write-Debug "-- Local Time --"
Write-Debug "Year: " + string(loo_Dt.Year)
Write-Debug "Month: " + string(loo_Dt.Month)
Write-Debug "Day: " + string(loo_Dt.Day)
Write-Debug "Hour: " + string(loo_Dt.Hour)
Write-Debug "Minutes: " + string(loo_Dt.Minute)
Write-Debug "Seconds: " + string(loo_Dt.Second)

destroy loo_Dt

// Get a DtObj in the GMT/UTC timezone.
li_BLocalTimezone = 0
loo_Dt = loo_DateTime.GetDtObj(li_BLocalTimezone)

// Get the individual date/time components
Write-Debug "-- UTC Time --"
Write-Debug "Year: " + string(loo_Dt.Year)
Write-Debug "Month: " + string(loo_Dt.Month)
Write-Debug "Day: " + string(loo_Dt.Day)
Write-Debug "Hour: " + string(loo_Dt.Hour)
Write-Debug "Minutes: " + string(loo_Dt.Minute)
Write-Debug "Seconds: " + string(loo_Dt.Second)

destroy loo_Dt


destroy loo_DateTime