Lua Requires Chilkat v9.5.0.73+

JSON Date Parsing

See more JSON Examples

Demonstrates how to parse date/time strings from JSON. Lua

local chilkat = require("chilkat")

local json = chilkat.JsonObject.new()
json.emit_compact = false

-- First, let's create JSON containing some date/time strings.
json:update_string("test.timestamp", "2018-01-30T20:35:00Z")
json:update_string("test.rfc822", "Tue, 24 Apr 2018 08:47:03 -0500")
json:update_string("test.dateStrings[0]", "2018-01-30T20:35:00Z")
json:update_string("test.dateStrings[1]", "Tue, 24 Apr 2018 08:47:03 -0500")
json:update_number("test.StartLoggingTime", "1446834998.695")
json:update_number("test.Expiration", "1442877512.0")
json:update_int("test.StartTime", 1518867432)

print(json:emit())

-- 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.
local dateTime = chilkat.DateTime.new()
local dt = chilkat.DtObj.new()
local getAsLocal = false

-- Load the date/time at test.timestamp into the dateTime object.
local success = json:date_of("test.timestamp", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))
print(dateTime:get_as_unix_time(false))
print(dateTime:get_as_rfc822(getAsLocal))

success = json:date_of("test.rfc822", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))

json.i = 0
success = json:date_of("test.dateStrings[i]", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))

json.i = 1
success = json:date_of("test.dateStrings[i]", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))

success = json:date_of("test.StartLoggingTime", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))

success = json:date_of("test.Expiration", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))

success = json:date_of("test.StartTime", dateTime)
print(dateTime:get_as_timestamp(getAsLocal))

-- 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:dt_of("test.timestamp", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

success = json:dt_of("test.rfc822", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

json.i = 0
success = json:dt_of("test.dateStrings[i]", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

json.i = 1
success = json:dt_of("test.dateStrings[i]", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

success = json:dt_of("test.StartLoggingTime", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

success = json:dt_of("test.Expiration", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

success = json:dt_of("test.StartTime", getAsLocal, dt)
print("month=" .. dt.month .. ", day=" .. dt.day .. ", year=" .. dt.year .. ", hour=" .. dt.hour .. ", minute=" .. dt.minute)

-- 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