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行记录)
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
