刚发完就在网上查到了。。CREATE OR REPLACE FUNCTION "unix_to_oracle" (in_number IN NUMBER) RETURN DATE AS BEGIN RETURN ( TO_DATE ('19700101', 'yyyymmdd') + in_number / 86400 + TO_NUMBER (SUBSTR (TZ_OFFSET (SESSIONTIMEZONE),1,3))/24 ) ; END;
select to_char( to_date('1970-01-01','yyyy-mm-dd')+1404001192/24/60/60 ,'yyyy-mm-dd hh24:mi:ss') from dual; 不过你这个时间戳对应的时间应该是2014-06-29 00:19:52
FUNCTION "unix_to_oracle" (in_number IN NUMBER)
RETURN DATE
AS
BEGIN
RETURN (
TO_DATE ('19700101', 'yyyymmdd') + in_number / 86400 +
TO_NUMBER (SUBSTR (TZ_OFFSET (SESSIONTIMEZONE),1,3))/24
) ;
END;
to_date('1970-01-01','yyyy-mm-dd')+1404001192/24/60/60
,'yyyy-mm-dd hh24:mi:ss') from dual;
不过你这个时间戳对应的时间应该是2014-06-29 00:19:52