1.unix时间戳---》 时间@H_403_1@

@H_403_1@

秒@H_403_1@

@H_403_1@

# SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 1471313356 * INTERVAL '1 second';@H_403_1@

?column? @H_403_1@

------------------------@H_403_1@

2016-08-16 10:09:16+08@H_403_1@

(1 row)@H_403_1@

@H_403_1@

# SELECT TIMESTAMP WITHOUT TIME ZONE 'epoch' + 1471313356 * INTERVAL '1 second';@H_403_1@

?column? @H_403_1@

---------------------@H_403_1@

2016-08-16 02:09:16@H_403_1@

(1 row)@H_403_1@

@H_403_1@

@H_403_1@

# SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 1461033436.269 * INTERVAL '1 second';@H_403_1@

?column? @H_403_1@

----------------------------@H_403_1@

2016-04-19 10:37:16.269+08@H_403_1@

(1 row)@H_403_1@

@H_403_1@

@H_403_1@

毫秒@H_403_1@

@H_403_1@

@H_403_1@

# SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 1464186650352 * INTERVAL '1 milliseconds';@H_403_1@

?column? @H_403_1@

----------------------------@H_403_1@

2016-05-25 22:30:50.352+08@H_403_1@

(1 row)@H_403_1@

@H_403_1@

# SELECT TIMESTAMP WITHOUT TIME ZONE 'epoch' + 1464186650352 * INTERVAL '1 milliseconds';@H_403_1@

?column? @H_403_1@

-------------------------@H_403_1@

2016-05-25 14:30:50.352@H_403_1@

(1 row)@H_403_1@

@H_403_1@

#@H_403_1@

@H_403_1@

@H_403_1@

2.时间----》 Unix时间戳@H_403_1@

@H_403_1@

秒@H_403_1@

@H_403_1@

# SELECT EXTRACT(EPOCH FROM TIMESTAMP WITHOUT TIME ZONE '2016-05-25 14:30:50.352');@H_403_1@

date_part @H_403_1@

----------------@H_403_1@

1464186650.352@H_403_1@

(1 row)@H_403_1@

@H_403_1@

# SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2016-05-25 14:30:50.352');@H_403_1@

date_part @H_403_1@

----------------@H_403_1@

1464157850.352@H_403_1@

(1 row)@H_403_1@

@H_403_1@

@H_403_1@

毫秒@H_403_1@

# SELECT EXTRACT(EPOCH FROM TIMESTAMP WITHOUT TIME ZONE '2016-05-25 14:30:50.352')*1000;@H_403_1@

?column? @H_403_1@

---------------@H_403_1@

1464186650352@H_403_1@

(1 row)@H_403_1@

@H_403_1@

#@H_403_1@