CkPython Requires Chilkat v11.0.0+

Parse a Microsoft JSON Date (MS AJAX Date)

See more JSON Examples

Demonstrates how to parse a Microsoft JSON Date, also known as an MSAJAX date. CkPython

import sys
import chilkat

success = False

#  Parse Microsoft JSON Dates (AJAX Dates)
json = chilkat.CkJsonObject()

success = json.Load("{ \"AchievementDate\":\"/Date(1540229468330-0500)/\"}")

dt = chilkat.CkDateTime()
success = json.DateOf("AchievementDate",dt)
if (success != True):
    print("Unable to parse a date/time.")
    sys.exit()

#  Show the date in different formats:
bLocal = True
print("RFC822: " + dt.getAsRfc822(bLocal))
print("Timestamp: " + dt.getAsTimestamp(bLocal))
print("YYYY-MM-DD: " + dt.getAsIso8601("YYYY-MM-DD",bLocal))

#  Get integer values for year, month, day, etc.
dtObj = chilkat.CkDtObj()
dt.ToDtObj(bLocal,dtObj)

print("year: " + str(dtObj.get_Year()))
print("month: " + str(dtObj.get_Month()))
print("day: " + str(dtObj.get_Day()))
print("hour: " + str(dtObj.get_Hour()))
print("minute: " + str(dtObj.get_Minute()))
print("seconds: " + str(dtObj.get_Second()))

#  Sample output:
#  RFC822: Mon, 22 Oct 2018 17:31:08 -0500
#  Timestamp: 2018-10-22T17:31:08-05:00
#  YYYY-MM-DD: 2018-10-22
#  year: 2018
#  month: 10
#  day: 22
#  hour: 17
#  minute: 31
#  seconds: 8