Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> database_value problem
Hello!
I'm having problem with database_value syntax in the following statement in Developer 6:
if :SYSTEM.CURSOR_VALUE > sysdate then
copy
(TO_DATE(GET_ITEM_PROPERTY(:SYSTEM.CURRENT_ITEM,Database_value),'DD-MON-RR')
,:SYSTEM_CURRENT_ITEM;
end if;
For example: if I have a date field 12/12/91, which I change into 02/02/02. Because the date is higher then sysdate it gets database value but instead 12/12/91 (12/12/1991) I get 12/12/2091.
I really don't know how to solve the problem.
Thanks in advance, Boris
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.276 / Virus Database: 145 - Release Date: 3.9.01Received on Tue Sep 25 2001 - 05:52:00 CDT