1.时间戳转时间

CREATE OR REPLACE
FUNCTION tamp_to_date (i_timestamp IN NUMBER ) return DATE IS r_date DATE;
BEGIN
SELECT
	i_timestamp/(1000*60*60*24) + to_date('1970-01-01 08:00:00','yyyy/mm/dd hh:mi:ss') into r_date from dual;
return r_date;
END tamp_to_date;

 INSERT INTO earlywarning_programme (CREATE_TIME )
 VALUES
	(tamp_to_date (#{CREATETIME}))

2.时间转时间戳

CREATE OR REPLACE
FUNCTION date_to_tamp (i_date IN DATE ) return NUMBER IS r_timestamp NUMBER;
BEGIN
SELECT
	((i_date-to_date('1970-01-01','YYYY-MM-DD')) * 86400 - 8*3600)*1000 into r_timestamp from dual; 
return r_timestamp;
END date_to_tamp;

 date_to_tamp(create_time) as create_time,

时间戳转时间CREATE OR REPLACEFUNCTION tamp_to_date (i_timestamp IN NUMBER ) return DATE IS r_date DATE;BEGINSELECT i_timestamp/(1000*60*60*24) + to_date('1970-01-01 08:00:00','yyyy/mm/dd hh:mi:ss') i... 2021-12-28 15:43:57 格式的 转换 为 时间戳 select (to_date('2021-12-28 15:43:57', 'yyyy-mm-dd hh24:mi:ss') - to_date('1970-01-01 08:00:00', 'yyyy-mm-dd hh24:mi:ss')) * 86400000 from dual; --1640677437000 2021年12月28日 格式的 转换 为 时间戳 select (to_date('20 create or replace function sec_to_date(v_date number) RETURN date IS v_srcdate number(15); v_tmp number(15); v_year varchar2(10); v_hour varchar2(10); v_min varchar2(10); v_sec varchar2(10); v_out_date date; begin v_srcdate:=v_date+8*