PostgreSQL contains pm/am time format conversion To_timestamp

PostgreSQL Help Documentation

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 formattedstrings< C10>tospecific data types.

gpsdata= #selectTo_timestamp(' Sep10:51:46:163PM', ' Mon DD YYYYHH -: MI:SS:MSPM');

To_timestamp

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

2010-09-2822:51:46.163+08

(1 Line records )

Gpsdata= #select to_timestamp(' Sep10:51:46:163AM', ' Mon DD YYYYHH24 : MI:SS:MSAM');

To_timestamp

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

2010-09-2810:51:46.163+08

(1 Line records )

Gpsdata= #select to_timestamp(' Sep 10:51:46:163PM', ' Mon DD YYYY HH12 : MI:SS:MSPM');

To_timestamp

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

2010-09-2822:51:46.163+08

(1 Line records )

Gpsdata= #select to_timestamp(' Sep 10:51:46:163AM', ' Mon DD YYYY HH12 : MI:SS:MSAM');

To_timestamp

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

2010-09-2810:51:46.163+08

(1 Line records )

PostgreSQL contains pm/am time format conversion To_timestamp