Re: Using to_date function in Forms 5

I would recommend that you download and read the white paper

"Oracle Developer Date Handling"

From http://www.oracle.com/year2000/white.html

This will explain what influences the ways dates are formatted under various circumstances.

--
Regards
Duncan Mills
Enterprise Internet Tools - Product Management

Email: drmills_at_uk.oracle.com
Tel:    +44 1962 853381
Fax:   +44 1962 853381

wozi <wozi_at_dhc.net> wrote in message
news:E1C51D092BB8C1DC.741CA043A28CDCF7.BA49788789054251_at_lp.airnews.net...


> Using the scott.emp table:

>

> 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.

>

>

>