Using to_date function in Forms 5
Date: Sun, 5 Dec 1999 08:09:41 -0800
Message-ID: <E1C51D092BB8C1DC.741CA043A28CDCF7.BA49788789054251_at_lp.airnews.net>
[Quoted] Using the scott.emp table:
[Quoted] I specify the following default_where in set_block_property.
set_block_property('EMP',default_where,
'hiredate = (' || '''' || :block3.sdate || ''''
||','||''''||'DD-MON-YYYY'||''''||')');
NOTE: :block3.sdate is used to prompt the user to enter a date. I have
formated the text item as DD-MON-YYYY in the navigator
Now, lets's say user enter 17-DEC-1980 in the date prompt... When I check :system.last_query, I get the following value hiredate = to_date('17-DEC-80','DD-MON-YYYY')
Notice that the century is not included. This could be a problem for date after year 2000. What I really like to see is : hiredate = to_date('17-DEC-1980','DD-MON-YYYY')
Any help would be really appreciated. Received on Sun Dec 05 1999 - 17:09:41 CET