雪花时间戳-将毫秒值保留为。000000，存储在表中

Question

有人能告诉我处理这个问题的文档吗？

Answer 1

1）和2）文档（您链接到的）表示时间戳默认使用9dp，当您选择时，您看到的是演示格式问题，而不是存储问题。

select '2045-06-02 09:23:41.8666668'::text as ta
    ,'2045-06-02 09:23:41.9777779'::text as tb
    ,ta::timestamp ta_d, ta::timestamp(0) ta_0
    ,ta::timestamp(3) ta_3
    ,ta::timestamp(6) ta_6
    ,tb::timestamp tb_d, tb::timestamp(0) tb_0
    ,tb::timestamp(3) tb_3, tb::timestamp(6) tb_6)
    ,datediff('millisecond', ta_d, tb_d )
    ,datediff('millisecond', ta_0, tb_0 )
    ,datediff('millisecond', ta_3, tb_3 )
    ,datediff('millisecond', ta_6, tb_6 ),
    datediff('microsecond', ta_d, tb_d )
    ,datediff('microsecond', ta_0, tb_0 )
    ,datediff('microsecond', ta_3, tb_3 )
    ,datediff('microsecond', ta_6, tb_6 )
    ,datediff('nanosecond', ta_d, tb_d )
    ,datediff('nanosecond', ta_0, tb_0 )
    ,datediff('nanosecond', ta_3, tb_3 )
    ,datediff('nanosecond', ta_6, tb_6 )
    ;

默认情况下显示小数点后9位。

3）这是一个格式化的事情…