Lianja

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. Lianja

// 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("CkDateTime")
loDateTime.SetFromTimestamp(lcStrTimestamp)

// Get a DtObj in the local timezone.
llBLocalTimezone = .T.
loDt = createobject("CkDtObj")
loDateTime.ToDtObj(llBLocalTimezone,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.
llBLocalTimezone = .F.
loDateTime.ToDtObj(llBLocalTimezone,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