Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> ora-01841
gurus,
i need ur help.... i have a forms that compare 2 dates . when i run it as client server, no error occur but when i transferred it to my nt web server application and run it from the web browser, an error occur
ora-01841:full year must be between -4713 and +9999 and not be 0.
here's a sample code
if to_char(date1,'MMDDYYYY') = to_char(date2,'MMDDYYYY') then
do some actions
end if;
is there something wrong w/ the stmt? what do i have to do?
thanks ! and HAPPY NEW YEAR TO ALL OF U
Grace Lim
Suy Sing Comm'l Corp.
Received on Thu Dec 28 2000 - 23:01:51 CST