Decode This Into Readable Time?

Aiden_12114 · July 6, 2020, 6:14am

So, I was working with Trello’s API and Due Dates. I then found out that the Due Date is in a weird format.

Is there anyways I can convert it to readable time?

Algorist · July 6, 2020, 7:28am

It’s currently in ISO 8601 date format, I don’t believe that Roblox has any built-in way to convert it.
But there’s a script that I found that converts ISO 8601 to the same format as os.date()

gist.github.com

https://gist.github.com/zwh8800/9b0442efadc97408ffff248bc8573064

datetime.lua

function parse_json_date(json_date)
    local pattern = "(%d+)%-(%d+)%-(%d+)%a(%d+)%:(%d+)%:([%d%.]+)([Z%+%-])(%d?%d?)%:?(%d?%d?)"
    local year, month, day, hour, minute, 
        seconds, offsetsign, offsethour, offsetmin = json_date:match(pattern)
    local timestamp = os.time{year = year, month = month, 
        day = day, hour = hour, min = minute, sec = seconds}
    local offset = 0
    if offsetsign ~= 'Z' then
      offset = tonumber(offsethour) * 60 + tonumber(offsetmin)
      if xoffset == "-" then offset = offset * -1 end

This file has been truncated. show original

Aiden_12114 · July 6, 2020, 11:06am

Is there anyways to decode a timestamp though?

emojipasta · July 6, 2020, 1:17pm

local s = "2020-07-07T06:10:00.000Z"

function date(str)
  local data = {}
  local y,m,d,h,i,s,t=str:match"(%d+)-(%d+)-(%d+)T(%d+):(%d+):(%d+).(%d+)Z"
  data.year=y data.month=m data.day=d data.hour=h data.min=i data.sec=s data.milli=t
  data.sinceEpoch=os.time(data)
  return data
end

print(date(s).month)
print(date(s).sinceEpoch)