说明:greenplum和postgres数据库可以分别叫GP数据库和PG数据库;
1、时间转化(GP数据库):
查询情况:
olp_dnv=# select time from d_20190204 limit 10;
time
------------
1549209600
1549209600
1549209600
1549209900
1549209900
1549209900
1549210200
1549210200
1549210200
1549210200
(10 rows)
用abstime转换后:
olp_dnv=# select time::abstime from d_20190204 limit 10;
time
------------------------
2019-02-04 00:00:00+08
2019-02-04 00:00:00+08
2019-02-04 00:05:00+08
2019-02-04 00:05:00+08
2019-02-04 00:05:00+08
2019-02-04 00:10:00+08
2019-02-04 00:10:00+08
2019-02-04 00:10:00+08
2019-02-04 00:15:00+08
2019-02-04 00:15:00+08
(10 rows)
2、IP地址转化(PG数据库):
查询情况:
sss_center=# select ipaddr from table limit 5;
ipaddr
------------
3232269573
3232269629
3232270135
3232269827
3232269609
(5 rows)
转化后:
sss_center=# select ipaddr::inet from table limit 5;
ipaddr
----------------
192.168.133.5
192.168.133.61
192.168.135.55
192.168.134.3
192.168.133.41
(5 rows)