E notation issue


#1

Hi,

n1q1 query showing below data in cbq query tool.

  { "CreatedTimestamp": 1.444375015e+09,
        "DocType": "UserBeaconActivity",
        "UpdatedTimestamp": 1.444375015e+09

}

Unable to query rows with e-notation data.

select distinct a.* from default a where a.DocType=‘UserBeaconActivity’ AND a.CreatedTimeStamp = 1444375015 order by META(a).id

But Couchbase console showing below.

{“CreatedTimestamp”: 1444375015,
“DocType”: “UserBeaconActivity”,
“UpdatedTimestamp”: 1444375015
}
.


#2

Hi,

You have a typo in CreatedTimestamp. Please use: