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) > >