postgreSQL中含有PM/AM时间格式转换to_timestamp

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行记录)