This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 83

Hi,


Regards,
Jaya
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1609
    
  13

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
 
Similar Threads
Prepared Statement and Date class
SQLException Cursor Closed
Oracler Date function
How to convert String to Date
getting Date and Time