【PostgreSQL】PostGreSQL数据库,时间数据类型

---"17:10:13.236"
time without time zone:时:分:秒.毫秒


---"17:10:13.236+08"
time with time zone:时:分:秒.毫秒+时区

---"2016-06-02 17:18:25.281"
timestamp without time zone:年月日时:分:秒.毫秒

---"2016-06-02 17:18:25.281+08"
timestamp with time zone:年月日时:分:秒.毫秒+时区

详细可学习PostgreSQL官网:https://www.postgresql.org/docs/9.2/static/functions-formatting.html

记录完成。

原文地址:https://www.cnblogs.com/KLLQBKY/p/5568968.html