OOS_UTIL_DATE
DATE2EPOCH Function
Coverts date to Unix Epoch time
Syntax
function date2epoch(
p_date in date)
return number
Parameters
| Name | Description |
|---|---|
p_date |
Date to convert to Epoch format |
| return | Unix Epoch time |
Example
select oos_util_date.date2epoch(sysdate)
from dual;
OOS_UTIL_DATE.DATE2EPOCH(SYSDATE)
---------------------------------
1461663997
EPOCH2DATE Function
Converts Unix linux time to Oracle date
Syntax
function epoch2date(
p_epoch in number)
return date
Parameters
| Name | Description |
|---|---|
p_epoch |
Epoch Unix date (number) |
| return | date |
Example
select oos_util_date.epoch2date(1461663982)
from dual;
OOS_UTIL_DATE.EPOCH2DATE(1461663982)
------------------------------------
26-APR-2016 12:46:22