How to use unixtime with $dateToString mongodb

Question

is't possible to use unixtime with $dateToString.

this is the schema:

var wifiSchema = mongoose.Schema({
  ID: String,
  Vendor: String,
  SSID: String,
  TimeStamp: {
    date: Number,
  },
  AP: String,
  MAC: String,
  ID_frame: String,
  RSSI: Number,
  Type: String
}, { collection: 'wifiScan' });

var wifi = mongoose.model('wifi', wifiSchema);

and this is the mongoose function:

wifi.aggregate([

  {$group:{_id:{"time" : "$TimeStamp.date"},uniqueCount: {$addToSet: "$MAC"}}},
  {$project:{"time":1,uniqueCustomerCount:{$size:"$uniqueCount"}, yearMonthDayUTC: { $dateToString: { format: "%Y/%m/%d", date: new Date('$$TimeStamp.date') } } } },
    {$sort:{'uniqueCustomerCount': -1 }}
    ]).limit(20).exec().then(notes => {
      res.status(200).json({data:notes});
      console.log(notes);
    });

The problem that I get an error on converting the date variable from unix fo date format using $dateToString, this is the result I get:

  { _id: { time: 1529235720000 },
    uniqueCustomerCount: 26,
    yearMonthDayUTC: '1970/01/01' } ]

I don't know why I get is as '1970/01/01'. thanks for the help.

Second try:

I have tried this $project example also:

 {$project:{"time":1,uniqueCustomerCount:{$size:"$uniqueCount"},"Time": { "$add": [ new Date(0), "$TimeStamp.date" ]} } },

See https://stackoverflow.com/questions/29892152/convert-milliseconds-to-date-in-mongodb-aggregation-pipeline-for-group-by — JohnnyHK, Jun 29 '18 at 16:27
@JohnnyHK I have tried to add that solution, but the same problem. — ahmed, Jun 29 '18 at 17:56
Ok, can you edit this question to show what you're trying now? — JohnnyHK, Jun 29 '18 at 17:57
@JohnnyHK, I have updated the $project as {$project:{"time":1,uniqueCustomerCount:{$size:"$uniqueCount"},"txnTime": { "$add": [ new Date(0), "$TimeStamp.date" ]} } }, — ahmed, Jun 29 '18 at 19:08
Can you [edit] your question to include that in context? Comments don't work well for code. — JohnnyHK, Jun 29 '18 at 19:17
@JohnnyHK, the same problem, I have add $dateToString for Time var, the same prob, I got "1970/01/01" as output — ahmed, Jun 29 '18 at 22:43
You need to keep your question updated with what you're trying so we can help you get it working. — JohnnyHK, Jun 30 '18 at 02:28
@JohnnyHK, i you know the solution please share, I have share all the solutions that I have tried — ahmed, Jun 30 '18 at 13:58

How to use unixtime with $dateToString mongodb

0 Answers0