|
Chilkat • HOME • .NET Core C# • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi ActiveX • Delphi DLL • Go • Java • Lianja • Mono C# • Node.js • Objective-C • PHP ActiveX • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift 2 • Swift 3,4,5... • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(Classic ASP) JSON Date ParsingDemonstrates how to parse date/time strings from JSON. Note: This example uses the DtOf and DateOf methods introduced in Chilkat v9.5.0.73
<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <% ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject") set json = Server.CreateObject("Chilkat.JsonObject") json.EmitCompact = 0 ' First, let's create JSON containing some date/time strings. success = json.UpdateString("test.timestamp","2018-01-30T20:35:00Z") success = json.UpdateString("test.rfc822","Tue, 24 Apr 2018 08:47:03 -0500") success = json.UpdateString("test.dateStrings[0]","2018-01-30T20:35:00Z") success = json.UpdateString("test.dateStrings[1]","Tue, 24 Apr 2018 08:47:03 -0500") success = json.UpdateNumber("test.StartLoggingTime","1446834998.695") success = json.UpdateNumber("test.Expiration","1442877512.0") success = json.UpdateInt("test.StartTime",1518867432) Response.Write "<pre>" & Server.HTMLEncode( json.Emit()) & "</pre>" ' 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. ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.CkDateTime") set dateTime = Server.CreateObject("Chilkat.CkDateTime") ' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.DtObj") set dt = Server.CreateObject("Chilkat.DtObj") getAsLocal = 0 ' Load the date/time at test.timestamp into the dateTime object. success = json.DateOf("test.timestamp",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsUnixTime(0)) & "</pre>" Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsRfc822(getAsLocal)) & "</pre>" success = json.DateOf("test.rfc822",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" json.I = 0 success = json.DateOf("test.dateStrings[i]",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" json.I = 1 success = json.DateOf("test.dateStrings[i]",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" success = json.DateOf("test.StartLoggingTime",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" success = json.DateOf("test.Expiration",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" success = json.DateOf("test.StartTime",dateTime) Response.Write "<pre>" & Server.HTMLEncode( dateTime.GetAsTimestamp(getAsLocal)) & "</pre>" ' 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: success = json.DtOf("test.timestamp",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" success = json.DtOf("test.rfc822",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" json.I = 0 success = json.DtOf("test.dateStrings[i]",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" json.I = 1 success = json.DtOf("test.dateStrings[i]",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" success = json.DtOf("test.StartLoggingTime",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" success = json.DtOf("test.Expiration",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" success = json.DtOf("test.StartTime",getAsLocal,dt) Response.Write "<pre>" & Server.HTMLEncode( "month=" & dt.Month & ", day=" & dt.Day & ", year=" & dt.Year _ & ", hour=" & dt.Hour & ", minute=" & dt.Minute) & "</pre>" ' 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 %> </body> </html> |
||||
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.