postgreSQL中含有PM/AM時間格式轉換to_timestamp

標籤：postgresql   時間格式函數   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行記錄) 

postgreSQL中含有PM/AM時間格式轉換to_timestamp