Date format for item updated_at

monday Apps & Developers
1

What date format is "2020-08-20 16:43:14 UTC"? It is found in boards{items{updated_at}} and differs from the ISO-8601 format in boards{updated_at} and elsewhere in the data. Javascript seems ok parsing it, but I’m just doing due diligence to make sure.

example graphql:

{
  boards(ids:0){
    name
    updated_at
    items(ids:0) {
      name
      column_values(ids:"date") {
        id
        title
        value
        text
      }
      updated_at
    }
  }
}

response:

image
image819×506 30.2 KB

3

Hey @jimcullison - sorry for our delay in handling this!

You are correct that it’s a different format - specifically because ISO8601 uses the TZ syntax to represent timezones and isn’t explicitly in the UTC format.

Updated_At is using a different common format but includes UTC as you pointed out in your example:

2020-08-20 16:43:14 UTC

Javascript should be able to parse this correctly though - if you’re seeing otherwise please let us know.

-Daniel