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

Home -> Community -> Usenet -> c.d.o.misc -> database_value problem

database_value problem

From: <zajcREMOVE_at_gmx.li>
Date: Tue, 25 Sep 2001 12:52:00 +0200
Message-ID: <9opnhd$fgn$1@planja.arnes.si>


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.01
Received on Tue Sep 25 2001 - 05:52:00 CDT

Original text of this message

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