Re: Using to_date function in Forms 5
From: Wim Jans <wim_at_cereus.be>
Date: Mon, 06 Dec 1999 14:49:03 GMT
Message-ID: <01bf3ff8$ea18db00$380210ac_at_wja.kodela.iuh.an>
> 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.
>
>
>
>
Received on Mon Dec 06 1999 - 15:49:03 CET
Date: Mon, 06 Dec 1999 14:49:03 GMT
Message-ID: <01bf3ff8$ea18db00$380210ac_at_wja.kodela.iuh.an>
Hi,
You could put the next 2 undocumented commands in your when-new-form-instance trigger
set_application_property(builtin_date_format,'DD-MON-YYYY'); set_application_property(plsql_date_format,'DD-MON-YYYY');
The latter will solve your problem (forms 5.0).
Hope this helps
Wim
wozi <wozi_at_dhc.net> wrote in article <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.
>
>
>
>
Received on Mon Dec 06 1999 - 15:49:03 CET