Oracle Database Discussions

Hi all,

I'm migrating some functions and stored procedures from MySQL to ORACLE, and I have the next instruction

set valuedat =  FROM_UNIXTIME( valor  +  UNIX_TIMESTAMP('2000-1-01 00:00:00'));

From MySQL.

Looking for I found that:

UNIX_TIMESTAMP('2000-1-01 00:00:00')

may be equivalent to the next query:

SELECT (to_date('01-jan-2000', 'DD-MON-YYYY') - to_date('01-jan-1970','DD-MON-YYYY')) * (86400) as dt FROM dual;

but testing the numbers are not the same

please somebody can help me!!

Specifically I need to know how to build the equivalent in oracle for the  functions  FROM_UNIXTIME and UNIX_TIMESTAMP

Thanks and regards!

//MGRC