ora-936: version differences

From: Antti Järvinen <costello_at_iki.fi>
Date: 19 Oct 2001 13:33:57 +0300
Message-ID: <m3sncfkjfu.fsf@muikku.baana.suomi.net>

Dear Sirs,

any ideas why
 select hiredate from emp where hiredate =  (
  select min(hiredate) from emp where hiredate in   (
   ( to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss') -

     (select min(abs(hiredate-
       to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss'))) from emp)

)

    ,
   ( to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss') +

     (select min(abs(hiredate-
       to_date('18.10.2001 15:11:58','dd.mm.yyyy hh24:mi:ss'))) from emp)

)

  )
 ) ;

returns a time with server version 816 and ora-936 on 734 and 804 I also tried? there is nothing very special about the query, isn't there?

-- 
Antti Järvinen, costello_at_iki.fi
            "concerto for two faggots and orchestra" 

Received on Fri Oct 19 2001 - 05:33:57 CDT