grond

ArcGIS 10 SDE date storage issue [ UNIX EPOCH vs. DateTime2 ]

Discussion created by grond on Nov 30, 2010
Hi,

I'm posting to a FEATURE LAYER using updateFeatures and  I can successfully post my JSON to the server.

However, when I pull back the data, my UPDATEDATE field is wrong.

Has anybody else seen this issue?
Originally the field was DateTime2...but we changed it to DateTime. Still, the date is not stored properly...Not sure what to do at this point. Any suggestions would be welcomed!

POST DATA:
[{"geometry":{"x":487278.0722,"y":4983429.5862},"attributes":{"ADD_ID_NAT":"02396435-ADDR0004116","ADD_ID_LOC":"ADDR0004116","ANUMBERPRE":" ","ANUMBER":1454,"ANUMBERSUF":" ","SHAPE.fid":9062,"ANUMBERSEP":" ","ST_PRE_MOD":" ","ST_PRE_DIR":" ","ST_PRE_TYP":" ","ST_NAME":"Eldridge","ST_POS_TYP":"Avenue","ST_POS_DIR":"West","ST_POS_MOD":" ","SUB_TYPE1":" ","SUB_ID1":" ","SUB_TYPE2":" ","SUB_ID2":" ","MUNI_NAME":"Roseville","MUNI_CODE":"02396435","USPS_PLACE":"Roseville","CO_CODE":"123","CO_NAME":"Ramsey","STATE_CODE":"MN","ZIP":"55113","ZIP4":" ","LOC_DESC":" ","LANDMARK":" ","RESIDENCE":"Yes","MAILABLE":" ","STATUS":"R","PIN":"152923210077","LONGITUDE":-93.1614262431,"LATITUDE":45.0041995117,"POSI_ACCU":3,"ADIRSOURCE":"Community Development","AAUTHORITY":"City of Roseville","EDIT_ORG":"City of Roseville","UPDATEDATE":1291134907,"COMMENTS":" "}}]

Here is the response JSON:
{"updateResults":[{"objectId":9062,"globalId" : null,"success":true}]}

Here's the JSON I get back when I search on the OBJECTID of the above edit:
"features" : [
    {
      "geometry" : {
        "x" : 487278.0722,
        "y" : 4983429.5861999998
      },
      "attributes" : {
        "ADD_ID_NAT" : "02396435-ADDR0004116",
        "ADD_ID_LOC" : "ADDR0004116",
        "ANUMBERPRE" : "",
        "ANUMBER" : 1454,
        "ANUMBERSUF" : "",
        "ANUMBERSEP" : "",
        "ST_PRE_MOD" : "",
        "ST_PRE_DIR" : "",
        "ST_PRE_TYP" : "",
        "ST_NAME" : "Eldridge",
        "ST_POS_TYP" : "Avenue",
        "ST_POS_DIR" : "West",
        "ST_POS_MOD" : "",
        "SUB_TYPE1" : "",
        "SUB_ID1" : "",
        "SUB_TYPE2" : "",
        "SUB_ID2" : "",
        "MUNI_NAME" : "Roseville",
        "MUNI_CODE" : "02396435",
        "USPS_PLACE" : "Roseville",
        "CO_CODE" : "123",
        "CO_NAME" : "Ramsey",
        "STATE_CODE" : "MN",
        "ZIP" : "55113",
        "ZIP4" : "",
        "LOC_DESC" : "",
        "LANDMARK" : "",
        "RESIDENCE" : "Yes",
        "MAILABLE" : "",
        "STATUS" : "R",
        "PIN" : "152923210077",
        "LONGITUDE" : -93.161426243099996,
        "LATITUDE" : 45.004199511700001,
        "POSI_ACCU" : 3,
        "ADIRSOURCE" : "Community Development",
        "AAUTHORITY" : "City of Roseville",
        "EDIT_ORG" : "City of Roseville",
        "UPDATEDATE" : 1291135000,
        "COMMENTS" : "",
        "SHAPE.fid" : 9062
      }
    }
  ]


Field Description:
UPDATEDATE (Type: esriFieldTypeDate, Alias: UPDATEDATE, Length: 36, Editable: True)

Outcomes