select
trunc(to_date('2010-9-18 49:58:26' ,'yyyy-mm-dd ') - sysdate) || '天' ||
to_char(to_date(trunc(
(
(to_date('2010-9-18' ,'yyyy-mm-dd') - sysdate) -
trunc(to_date('2010-9-18' ,'yyyy-mm-dd')- sysdate)
) *
86400),
'SSSSS'),
'fmhh24"小时"mi"分"ss"秒"')
from etp_ord eo;
trunc(to_date('2010-9-18 49:58:26' ,'yyyy-mm-dd ') - sysdate) || '天' ||
to_char(to_date(trunc(
(
(to_date('2010-9-18' ,'yyyy-mm-dd') - sysdate) -
trunc(to_date('2010-9-18' ,'yyyy-mm-dd')- sysdate)
) *
86400),
'SSSSS'),
'fmhh24"小时"mi"分"ss"秒"')
from etp_ord eo;