Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ora-01841

ora-01841

From: grace lim <mglim_at_softhome.net>
Date: Fri, 29 Dec 2000 13:01:51 +0800
Message-Id: <10724.125431@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US