CkPython

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