Handling of date/time values

[wbuchanan]

jsonio command is not handling datetime types in a good way:

. webuse irates4, clear
(St. Louis Fed (FRED) financial data)

. jsonio in 1/2, w(all)
{
  "data" : [ {
    "date" : 770.0,
    "sp500" : 2.521008884397957,
    "t" : 1.0,
    "tbill" : 2.92,
    "bond" : 4.42
  }, {
    "date" : 777.0,
    "sp500" : 2.2208934130985165,
    "t" : 2.0,
    "tbill" : 3.0,
    "bond" : 4.43
  } ],
  "firstObservationId" : 1,
  "lastObservationId" : 2,
  "numberRecords" : 2,
  "variableIndices" : [ 1, 2, 3, 4, 5 ],
  "numberVariables" : 5,
  "variableTypeIsString" : {
    "date" : false,
    "sp500" : false,
    "t" : false,
    "tbill" : false,
    "bond" : false
  },
  "variableNames" : [ "t", "tbill", "date", "bond", "sp500" ],
  "variableLabels" : {
    "date" : "Date",
    "sp500" : "S&P 500 return",
    "t" : "Sequential time: weeks since 09feb1962",
    "tbill" : "6-Month Treasury bill: secondary market rate",
    "bond" : "Moody's seasoned AAA Corporate bond yield"
  },
  "valueLabelNames" : { },
  "valueLabels" : { },
  "observationIndex" : [ 1, 2 ]
}

It'd be better to get the formatted string values for the dates and/or create Java date values to substitute in place of the SIF dates.

[wbuchanan]

Patched the date/time bug (as best as understood) :

. run jsonio.ado
. webuse irates4, clear
(St. Louis Fed (FRED) financial data)

. jsonio in 1/3, what(all)
{
  "data" : {
    "source" : "http://www.stata-press.com/data/r14/irates4.dta",
    "values" : [ {
      "date" : "1962/02/09",
      "sp500" : 2.521008884397957,
      "t" : 1.0,
      "tbill" : 2.92,
      "bond" : 4.42
    }, {
      "date" : "1962/02/16",
      "sp500" : 2.2208934130985165,
      "t" : 2.0,
      "tbill" : 3.0,
      "bond" : 4.43
    }, {
      "date" : "1962/02/23",
      "sp500" : 1.4243309536188289,
      "t" : 3.0,
      "tbill" : 2.93,
      "bond" : 4.42
    } ]
  },
  "first record id" : 1,
  "last record id" : 3,
  "number of records" : 3,
  "variable indices" : [ 1, 2, 3, 4, 5 ],
  "number of variables" : 5,
  "variable type string" : {
    "date" : false,
    "sp500" : false,
    "t" : false,
    "tbill" : false,
    "bond" : false
  },
  "variable names" : [ "t", "tbill", "date", "bond", "sp500" ],
  "variable labels" : {
    "date" : "Date",
    "sp500" : "S&P 500 return",
    "t" : "Sequential time: weeks since 09feb1962",
    "tbill" : "6-Month Treasury bill: secondary market rate",
    "bond" : "Moody's seasoned AAA Corporate bond yield"
  },
  "value label names" : { },
  "value labels" : { }
}

[wbuchanan]

This is fixed on the dev branch.