Click to See Complete Forum and Search --> : ora-01843


burga
October 29th, 2009, 06:04 AM
hi , i'm calling to my db function with date parameter from crystal reports and getting
ORA-01834 :NOT A VALID MONTH error , i tried to change to any format (dd/mm/yyyy,dd-mon-yyyy,dd-mmm-yy and go on....) but still getting this error , please if anybody knows how to resolve this problem ill be glad to hear some advices , thanks

msmnithya
November 21st, 2009, 02:18 AM
hi,
change the format as yyyy-mm-dd or mm-dd-yyyy

greetings