From: fvanbortel@netscape.net   
      
   Steven Jackson wrote:   
   > Can anyone please help me with the cause of this error?   
   > ORA-01830: date format picture ends before converting entire input   
   > string   
   >   
   > I am performing the following statment in SQL+   
   > select count(*) from tableX where entry_date > '01-Jan-04 13.02.00';   
   > entry_date is a date field with the format dd-mon-rr however contains   
   > records with the HH.MM.SS format.   
   >   
   > In SQL+ I can use the to_date function however in the actual   
   > application that will not be possible or really useful for that   
   > matter.   
   >   
   > Can any give me some sugestions as to why the format does not seem to   
   > work or what can be done?   
   >   
   > Thanks in advance,   
   >   
   > Steven   
   > If possible please email me the reply so that I notice it faster.   
      
   where to_date( entry_date,'dd-mon-yy HH24.MI.SS') ...   
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)