test timestamp

Posted on 2013-04-25 17:36  JasmineLiu  阅读(190)  评论(0)    收藏  举报


highgo=# select '2013-7-8 23:23:23.9999989'::timestamp(6);
timestamp
----------------------------
2013-07-08 23:23:23.999999
(1 行记录)


highgo=# select '2013-7-8 23:23:23.9999984'::timestamp(6);
timestamp
----------------------------
2013-07-08 23:23:23.999998
(1 行记录)

博客园  ©  2004-2025
浙公网安备 33010602011771号 浙ICP备2021040463号-3