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


On Mon, Aug 13, 2012 at 6:04 AM, Massimo Manghi <mxman...@apache.org> wrote:

>
> I fixed and commited the classes Sqlite and Mysql and I'm going to fix
> also Postgresql. I could also fix the Oracle class. Oracle has no native
> way to return the Unix timestamp in SQL queries. A workaround exists but
> I don't have an Oracle installation to test it, so I please any Oracle
> user to volunteer for a test (I can provide simple scripts for testing
> it with the Session package)
>
>

Reply via email to