postgre 年月日转年月_Postgresql的字符串日期类型转换

[postgres:6446@postgres] [12-25.16:58:54]=# select '2015-10-12 14:33'::timestamp ;

timestamp

---------------------

2015-10-12 14:33:00

(1 row)

Time: 0.605 ms

[postgres:6446@postgres] [12-25.17:25:34]=# select '2015-10-12'::timestamp ;

timestamp

---------------------

2015-10-12 00:00:00

(1 row)

Time: 0.323 ms

[postgres:6446@postgres] [12-25.17:25:45]=# select cast('2015-10-12' as timestamp);

timestamp

---------------------

2015-10-12 00:00:00

(1 row)

Time: 0.352 ms

[postgres:6446@postgres] [12-25.17:26:13]=# select cast('2015/10/12' as timestamp);

timestamp

---------------------

2015-10-12 00:00:00

(1 row)

Time: 0.290 ms

[postgres:6446@postgres] [12-25.17:26:28]=# selec