Chilkat2-Python

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. Chilkat2-Python

import sys
import chilkat2

success = False

# Parse Microsoft JSON Dates (AJAX Dates)
json = chilkat2.JsonObject()

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

dt = chilkat2.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 = chilkat2.DtObj()
dt.ToDtObj(bLocal,dtObj)

print("year: " + str(dtObj.Year))
print("month: " + str(dtObj.Month))
print("day: " + str(dtObj.Day))
print("hour: " + str(dtObj.Hour))
print("minute: " + str(dtObj.Minute))
print("seconds: " + str(dtObj.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