orcale得到时间差1970-01-01 00:00:00——至今

round(to_number(to_date(to_char(sysdate,'yyyy-mm-dd'),'yyyy-mm-dd')-to_date('1970-01-01','yyyy-mm-dd')))*24*60*60*1000+
to_number(to_char(sysdate,'HH24'))*60*60*1000+
to_number(to_char(sysdate,'MI'))*60*1000+
to_number(to_char(sysdate,'SS'))*1000

posted on 2010-04-25 12:39  sdh  阅读(304)  评论(0)    收藏  举报

导航