PostgreSQL contains PM/AM Time Format Conversion to_timestamp, postgresql

PostgreSQL contains PM/AM Time Format Conversion to_timestamp, postgresql

PostgreSQL help documentation

9.8. Data Type Formatting Functions
The specified sqlformatting 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 line record)

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 line record)

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 line record)

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 line record)