Meaningless Drivel is fun!
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

ORA-01843: not a valid month

jaya kemmannu
Ranch Hand

Joined: Sep 23, 2011
Posts: 87


chris webster

Joined: Mar 01, 2009
Posts: 2295

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:
subject: ORA-01843: not a valid month
It's not a secret anymore!