This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund 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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Reply 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: 72
posted private message
0
Quote

Hi,


Regards,
Jaya
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1103
    
    7

I like...
Eclipse IDE Oracle Python
posted
0
Quote
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.

ex-Oracle bloke
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: ORA-01843: not a valid month
 
Similar Threads
How to convert String to Date
Oracler Date function
getting Date and Time
SQLException Cursor Closed
Prepared Statement and Date class