| |
Had been using PostgreSQL functions to piece together, today suddenly discovered they can be that simple, direct use of timestamp (0) to fix it up:
ls => select createtime :: timestamp (0) without time zone from users;
createtime
---------------------
2015-10-03 01:32:03
2015-10-03 01:32:03
2015-10-03 01:32:03
(3 rows)
ls => select createtime :: timestamp without time zone from users;
createtime
----------------------------
2015-10-0301: 32: 03.080415
2015-10-0301: 32: 03.080415
2015-10-0301: 32: 03.080415
(3 rows) |
|
|
|