PL/SQL sysdate到Unix纪元的毫秒数 [英] PL/SQL sysdate to Unix epoch time in ms
本文介绍了PL/SQL sysdate到Unix纪元的毫秒数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一堆Oracle sysdate值,需要将这些值转换为以毫秒为单位的Unix纪元时间.
I have bunch of Oracle sysdate values which need to be converted to Unix epoch time in ms.
例如具有值
15-MAR-13
应转换为
1363351108398
在PL/SQL中
那怎么办?
推荐答案
您可以使用此功能.它还考虑了时区,因为Unix时代是1970-01-01 00:00:00 UTC!
You can use this function. It also considers the time zone, because Unix epoche is 1970-01-01 00:00:00 UTC!
CREATE OR REPLACE FUNCTION GetEpoche(theTimestamp IN TIMESTAMP, timezone IN VARCHAR2 DEFAULT SESSIONTIMEZONE) RETURN NUMBER DETERMINISTIC IS
timestampUTC TIMESTAMP;
theInterval INTERVAL DAY(9) TO SECOND;
epoche NUMBER;
BEGIN
timestampUTC := FROM_TZ(theTimestamp, timezone) AT TIME ZONE 'UTC';
theInterval := TO_DSINTERVAL(timestampUTC - TO_TIMESTAMP('1970-01-01', 'YYYY-MM-DD') );
epoche := EXTRACT(DAY FROM theInterval)*24*60*60
+ EXTRACT(HOUR FROM theInterval)*60*60
+ EXTRACT(MINUTE FROM theInterval)*60
+ EXTRACT(SECOND FROM theInterval);
RETURN ROUND(1000*epoche);
END GetEpoche;
这篇关于PL/SQL sysdate到Unix纪元的毫秒数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文