Sample code for 30+ languages & platforms
AutoIt

JSON Date Parsing

See more JSON Examples

Demonstrates how to parse date/time strings from JSON.

Note: This example uses the DtOf and DateOf methods introduced in Chilkat v9.5.0.73

Chilkat AutoIt Downloads

Download Chilkat for AutoIt
AutoIt 
Local $bSuccess = False

$oJson = ObjCreate("Chilkat.JsonObject")
$oJson.EmitCompact = False

;  First, let's create JSON containing some date/time strings.
$oJson.UpdateString("test.timestamp","2018-01-30T20:35:00Z")
$oJson.UpdateString("test.rfc822","Tue, 24 Apr 2018 08:47:03 -0500")
$oJson.UpdateString("test.dateStrings[0]","2018-01-30T20:35:00Z")
$oJson.UpdateString("test.dateStrings[1]","Tue, 24 Apr 2018 08:47:03 -0500")
$oJson.UpdateNumber("test.StartLoggingTime","1446834998.695")
$oJson.UpdateNumber("test.Expiration","1442877512.0")
$oJson.UpdateInt("test.StartTime",1518867432)

ConsoleWrite($oJson.Emit() & @CRLF)

;  We've built the following JSON:

;  {
;    "test": {
;      "timestamp": "2018-01-30T20:35:00Z",
;      "rfc822": "Tue, 24 Apr 2018 08:47:03 -0500",
;      "dateStrings": [
;        "2018-01-30T20:35:00Z",
;        "Tue, 24 Apr 2018 08:47:03 -0500"
;      ],
;      "StartLoggingTime": 1446834998.695,
;      "Expiration": 1442877512.0,
;      "StartTime": 1518867432
;    }
;  }

;  Use the DateOf and DtOf methods to load Chilkat date/time objects with the date/time values.
;  The CkDateTime object is primarily for loading a date/time from numerous formats, and then getting
;  the date/time in various formats.  Thus, it's primarly for date/time format conversion.
;  The DtObj object holds a date/time where the individual components (day, month, year, hour, minutes, etc.) are 
;  immediately accessible as integers.
$oDateTime = ObjCreate("Chilkat.CkDateTime")
$oDt = ObjCreate("Chilkat.DtObj")
Local $bGetAsLocal = False

;  Load the date/time at test.timestamp into the dateTime object.
$bSuccess = $oJson.DateOf("test.timestamp",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)
ConsoleWrite($oDateTime.GetAsUnixTime(False) & @CRLF)
ConsoleWrite($oDateTime.GetAsRfc822($bGetAsLocal) & @CRLF)

$bSuccess = $oJson.DateOf("test.rfc822",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)

$oJson.I = 0
$bSuccess = $oJson.DateOf("test.dateStrings[i]",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)

$oJson.I = 1
$bSuccess = $oJson.DateOf("test.dateStrings[i]",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)

$bSuccess = $oJson.DateOf("test.StartLoggingTime",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)

$bSuccess = $oJson.DateOf("test.Expiration",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)

$bSuccess = $oJson.DateOf("test.StartTime",$oDateTime)
ConsoleWrite($oDateTime.GetAsTimestamp($bGetAsLocal) & @CRLF)

;  Output so far:

;  	2018-01-30T20:35:00Z
;  	1517344500
;  	Tue, 30 Jan 2018 20:35:00 GMT
;  	2018-04-24T13:47:03Z
;  	2018-01-30T20:35:00Z
;  	2018-04-24T13:47:03Z
;  	2015-11-07T00:36:38Z
;  	2015-09-22T04:18:32Z
;  	2018-02-17T17:37:12Z

;  Now load the date/time strings into the dt object:
$bSuccess = $oJson.DtOf("test.timestamp",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

$bSuccess = $oJson.DtOf("test.rfc822",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

$oJson.I = 0
$bSuccess = $oJson.DtOf("test.dateStrings[i]",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

$oJson.I = 1
$bSuccess = $oJson.DtOf("test.dateStrings[i]",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

$bSuccess = $oJson.DtOf("test.StartLoggingTime",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

$bSuccess = $oJson.DtOf("test.Expiration",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

$bSuccess = $oJson.DtOf("test.StartTime",$bGetAsLocal,$oDt)
ConsoleWrite("month=" & $oDt.Month & ", day=" & $oDt.Day & ", year=" & $oDt.Year & ", hour=" & $oDt.Hour & ", minute=" & $oDt.Minute & @CRLF)

;  Output:

;  month=1, day=30, year=2018, hour=20, minute=35
;  month=4, day=24, year=2018, hour=13, minute=47
;  month=1, day=30, year=2018, hour=20, minute=35
;  month=4, day=24, year=2018, hour=13, minute=47
;  month=11, day=6, year=2015, hour=18, minute=36
;  month=9, day=21, year=2015, hour=23, minute=18
;  month=2, day=17, year=2018, hour=11, minute=37