douquan1015 2018-01-02 13:45
浏览 359
已采纳

在带有mgo的查找查询中使用时间戳

I'm trying to run a fairly simple query using MGO that only has one condition included: published field must be less than or equal to the current time.

I have a test document in my database that was created as follows:

db.articles.insert([{
    "title": "Woo this is a test title",
    "published": ISODate("2017-01-02T12:00:00Z")
}])

My querying code is:

now := time.Now().Format(time.RFC3339)
articlesCollection.Find(bson.M{"published": bson.M{"$lte": now}}).
     Sort("-published").All(&frontPageArticles.Articles)

But I get no records returned.

I'm comfortable with Mongo, but very new to Go (and thus mgo) - I'm sure I'm doing something wrong at a basic level, but am not sure what. Can anyone help?

  • 写回答

1条回答 默认 最新

  • douweida2878 2018-01-02 13:48
    关注

    The solution is simple: don't format your time, just pass a time.Time value:

    now := time.Now()
    

    The mgo package will encode the time in the appropriate format. In your example you passed the time as a string which would only work if the published field in MongoDB would also be a string in the same format (and not a MongoDB date).

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
  • ¥100 连续两帧图像高速减法
  • ¥15 组策略中的计算机配置策略无法下发
  • ¥15 如何绘制动力学系统的相图
  • ¥15 对接wps接口实现获取元数据
  • ¥20 给自己本科IT专业毕业的妹m找个实习工作
  • ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?
  • ¥30 我的代码按理说完成了模型的搭建、训练、验证测试等工作(标签-网络|关键词-变化检测)