PostgreSQL帮助文档
9.8. Data Type Formatting Functions
The PostgreSQLformatting functionsprovide a powerful set of tools for converting various data types(date/time,
integer, floating point, numeric)to formatted strings and forconverting from formattedstringstospecific data types.
GPSData=#select to_timestamp(‘Sep 28 201010:51:46:163PM‘,‘Mon DD YYYYHH24:MI:SS:MSPM‘);
to_timestamp
----------------------------
2010-09-2822:51:46.163+08
(1行记录)
GPSData=#select to_timestamp(‘Sep 28 201010:51:46:163AM‘,‘Mon DD YYYYHH24:MI:SS:MSAM‘);
to_timestamp
----------------------------
2010-09-2810:51:46.163+08
(1行记录)
GPSData=#select to_timestamp(‘Sep 28 2010 10:51:46:163PM‘,‘Mon DD YYYY HH12:MI:SS:MSPM‘);
to_timestamp
----------------------------
2010-09-2822:51:46.163+08
(1行记录)
GPSData=#select to_timestamp(‘Sep 28 2010 10:51:46:163AM‘,‘Mon DD YYYY HH12:MI:SS:MSAM‘);
to_timestamp
----------------------------
2010-09-2810:51:46.163+08
(1行记录)
postgreSQL中含有PM/AM时间格式转换to_timestamp
原文：http://blog.csdn.net/yufenghyc/article/details/45674619