File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes ORA-01843: not a valid month Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORA-01843: not a valid month" Watch "ORA-01843: not a valid month" New topic
Author

ORA-01843: not a valid month

jaya kemmannu
Ranch Hand

Joined: Sep 23, 2011
Posts: 84

Hi,


Regards,
Jaya
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1671
    
  14

Your LAST_MODIFIED_TIME is (presumably) a date-time, but you are comparing it with character values from your TO_CHAR functions. Leave all the dates as dates and it should work. Also, you can use "BETWEEN date1 AND date2" to catch dates inside a range.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-01843: not a valid month