> Are you sure something like this will not work on Oracle?
>
> SELECT (SYSDATE - TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS'))
> *
> 24 * 60 * 60 FROM DUAL
Connected to:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
SQL> SELECT (SYSDATE - TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS'))
* 24 * 60 * 60 SECS FROM DUAL;
SECS
----------
1345051561
SQL>
hth
Ronnie
--
Ronnie Brunner | [email protected] | T +41-44-247 79 79 |
Netcetera AG | 8040 Zürich | Switzerland | http://netcetera.com |
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
