DB2查询当前时间与指定时间的时间差（相隔的秒数）

select  (DAYS(a.end_date) - DAYS(current timestamp)) * 86400 +
(MIDNIGHT_SECONDS(a.end_date) - MIDNIGHT_SECONDS(current timestamp)) from auct_item a