(CkPython) Parse a Microsoft JSON Date (MS AJAX Date)

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

Note: This example requires Chilkat v11.0.0 or greater.

Chilkat Python Downloads install with pip pip3 install chilkat or download... Python Module for Windows, MacOS, Linux, Alpine Linux

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