GP数据库求时间差

分钟差
date_part(‘min’,to_timestamp(‘2019-05-05 12:11:20’,‘yyyy-mm-dd hh24:mi:ss’)-to_timestamp(‘2019-05-05 10:10:10’,‘yyyy-mm-dd hh24:mi:ss’))

round(extract(epoch FROM (to_timestamp(‘2019-05-05 15:11:20’,‘yyyy-mm-dd hh24:mi:ss’)-to_timestamp(‘2019-05-05 10:10:10’,‘yyyy-mm-dd hh24:mi:ss’)))/60)

一 PostgreSQL 中的时间类型如下
Name Storage Size Description Low Value High Value Resolution
timestamp [ § ] [ without time zone ] 8 bytes both date and time (no time zone) 4713 BC 294276 AD 1 microsecond / 14 digits
timestamp [ § ] with time zone 8 bytes both date and time, with time zone 4713 BC 294276 AD 1 microsecond / 14 digits
date 4 bytes date (no time of day) 4713 BC 5874897 AD 1 day
time [ § ] [ without time zone ] 8 bytes time of day (no date) 00:00:00 24:00:00 1 microsecond / 14 digits
time [ § ] with time zone 12 bytes times of day only, with time zone 00:00:00+1459 24:00:00-1459 1 microsecond / 14 digits
interval [ fields ]