douyujun0152 2018-12-13 17:05
浏览 474
已采纳

在MongoDB中保存纳秒级时间戳(由Go生成,使用Node.js保存)

I am trying to store Unix timestamps in nanoseconds into the Date type field of a Mongodb database.

The unix timestamps in nanoseconds are generated in a Go program (with time.Now().UnixNano()), submitted to Kafa to be read by a Node.js script which uses mongoose to write the payload object containing the unix timestamp in nanoseconds to the Mongodb store.

However this is throwing an error

UnhandledPromiseRejectionWarning: ValidationError: trade validation failed: timestamp: Cast to Date failed for value "1544720051987010000" at path "timestamp"

Is there a better way to store unix timestamps in nanosecond in Mongodb?

  • 写回答

1条回答 默认 最新

  • dongzong8110 2018-12-13 17:45
    关注

    I am trying to store Unix timestamps in nanoseconds into the Date type field of a Mongodb database. Nyxynyx

    That is not going to work.


    Internally, Date objects are stored as a signed 64-bit integer representing the number of milliseconds since the Unix epoch (Jan 1, 1970).

    MongoDB Reference: Date()


    For example,

    package main
    
    import (
        "fmt"
        "time"
    )
    
    func main() {
        timestamp := time.Now().UnixNano() / int64(time.Millisecond)
        fmt.Println(timestamp)
    }
    

    Playground: https://play.golang.org/p/21S_DeVA4jv

    Output:

    1257894000000
    

    To store Unix nanoseconds, use the long data type.

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

报告相同问题?

悬赏问题

  • ¥15 Torch not compiled with CUDA enabled
  • ¥15 三种节点编号优化算法比较
  • ¥15 比特币ord程序wallet_constructor.rs文件支持一次性铸造1000个代币,并将它们分配到40个UTXO上(每个UTXO上分配25个代币),并设置找零地址
  • ¥115 用Java解决探地雷达dzt文件的解析过程
  • ¥20 有关神经网络这道(b)determine the parameters of neural network
  • ¥25 annaconda jvpyter
  • ¥20 来一个会抓包app支付接口的
  • ¥30 vivado2017.4的sdk打不开
  • ¥50 matlab,文献复现
  • ¥20 寻找Flink CDC指导,有偿咨询