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. Visual FoxPro

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"

loDateTime = CreateObject('Chilkat.CkDateTime')
loDateTime.SetFromTimestamp(lcStrTimestamp)

* Get a DtObj in the local timezone.
lnBLocalTimezone = 1
loDt = CreateObject('Chilkat.DtObj')
loDateTime.ToDtObj(lnBLocalTimezone,loDt)

* 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)

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

* 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 loDateTime
RELEASE loDt