Re: Convert Date to Number

On Thu, 10 Apr 2003 17:41:48 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>
>u can write a function to do that
>or just use a simple query like
>
>select sysdate-to_date('01/01/1970 00:00:00','dd/mm/yyyy')*24*60*60
>from dual

Which gives ORA-00932. You need a set or parentheses AND to complete the date format string :

select (sysdate-to_date('01/01/1970 00:00:00','dd/mm/yyyy hh24:mi:ss'))*24*60*60 from dual;

• Kenneth Koenraadt