Re: Millennial Fun with Oracle Dates

Hello,

Try to set following statements in wnfi trigger

set_application_property( builtin_date_format, 'dd-mm-yyyy'); set_application_property( plsql_date_format, 'dd-mm-yyyy');

This works for forms enhanced-release (4.5.7.15.8, 4.5.10, 5.0.6, ...)

I have an Oracle doc available ('Date handling in developer/2000'), explaining all the date issues in developer (forms, reports, ...). Very interesting lecture I must say.
If you want a copy of it (301kb, pdf format), drop a note at wim_at_cereus.be and I will sent you one.

Hope this helps

Wim

pberetta_at_my-deja.com wrote in article <850o7n$pmr$1_at_nnrp1.deja.com>...
> On a (slightly) more serious note, just in case someone out there has
> not already been 'bitten' by this one (or figured out what the heck is
> going on if they have) -
> In Oracle Forms, if you are storing a date to a GLOBAL variable, then
> populating a date with the GLOBAL, the results may suprise you now that
> we are in 2000. Oracle stores the date to the GLOBAL as a 9 character
> string in 'DD-MON-YY' format, when it is reconverted to a DATE, it
> assumes the current century - not what you want if the original date
> was in the 1900's!
> Paul
Received on Thu Jan 06 2000 - 16:19:23 CET