(Visual FoxPro) 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

LOCAL lcStrTimestamp
LOCAL loDateTime
LOCAL lnBLocalTimezone
LOCAL loDt

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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.CkDateTime')
loDateTime = CreateObject('Chilkat.CkDateTime')
loDateTime.SetFromTimestamp(lcStrTimestamp)

* Get a DtObj in the local timezone.
lnBLocalTimezone = 1
loDt = loDateTime.GetDtObj(lnBLocalTimezone)

* Get the individual date/time components
? "-- Local Time --"
? "Year: " + STR(loDt.Year)
? "Month: " + STR(loDt.Month)
? "Day: " + STR(loDt.Day)
? "Hour: " + STR(loDt.Hour)
? "Minutes: " + STR(loDt.Minute)
? "Seconds: " + STR(loDt.Second)

RELEASE loDt

* Get a DtObj in the GMT/UTC timezone.
lnBLocalTimezone = 0
loDt = loDateTime.GetDtObj(lnBLocalTimezone)

* Get the individual date/time components
? "-- UTC Time --"
? "Year: " + STR(loDt.Year)
? "Month: " + STR(loDt.Month)
? "Day: " + STR(loDt.Day)
? "Hour: " + STR(loDt.Hour)
? "Minutes: " + STR(loDt.Minute)
? "Seconds: " + STR(loDt.Second)

RELEASE loDt

RELEASE loDateTime