dtcyv3985 2016-09-20 02:25
浏览 331

$ oto中的$ dateToString不起作用

I wrote the code in Go. I have a mongodb query in mgo that has made me busy for 3 days and still fighting with it.

Though a query with mongo shell works, mongodb query with mgo does not work.

Below query and result are made with mongo shell.

// Query
db.getCollection("TEST").aggregate([
{
    "$match": {
        "date": {"$gte": new Date("2016-06-28"), "$lte": new Date("2016-06-29")},
    }
},
{
    "$project": {
        "_id": false,
        "date": {"$dateToString": {"format": "%Y%m%d", "date":"$date"}},
    },
},
]);


// Result
{
"date" : "20160628",
}
{
"date" : "20160629",
}

Below query and result are made with mgo. It doesn't work.

// Query
matchQuery := bson.M{}
matchQuery["date"] = bson.M{
    "$gte": time.Date(2016, 6, 28, 0, 0, 0, 0, time.UTC),
    "$lte": time.Date(2016, 6, 29, 23, 59, 59, 0, time.UTC),
}
projectQuery := bson.M{
    "_id": false,
    "date": bson.M{
        "$dateToString": bson.M{"format": "%Y%m%d", "date": "$date"},
    },
}
pipeline := []bson.M{
    {"$match": matchQuery},
    {"$project": projectQuery},
}


// Result
{
    "date": "0001-01-01T00:00:00Z",
},

{
    "date": "0001-01-01T00:00:00Z",
}

How can I work $dateToString correctly?

  • 写回答

1条回答 默认 最新

  • duanqun7761 2016-09-23 01:15
    关注

    I solved it. It was my mistake. I post the answer so that anyone does not make a mistake like me. I didn't change variable type from "time.Time" to "string" like below.

    //Old
    type content struct {
        Date  time.Time `bson:"date" json:"date"`
    }
    
    //New
    type content struct {
        Date  string `bson:"date" json:"date"`
    }
    

    Thanks :)

    评论

报告相同问题?

悬赏问题

  • ¥15 vscode的问题提问
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思
  • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
  • ¥15 划分vlan后,链路不通了?
  • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
  • ¥15 Vue3 大型图片数据拖动排序
  • ¥15 Centos / PETGEM