gee, nevermind, guys... fixed it...
I replaced the to_timestamp() 's with to_date(date_value,date_format) 's and now it works
Still not sure why the timestamp didn't work... anywayz
used 'dd/mm/yyyy hh24:mi:ss'
hope it helps somebody else!
thanx for anybody who read all this (ouch!)
http://arjudba.blogspot.com/2008/06/ora-01843-not-valid-month.html
No comments:
Post a Comment