Re: Millennial Fun with Oracle Dates

[Quoted] Hello Paul,

Which version of Oracle Forms do you use?

After this code in Forms 6.0.5.33.0:

  declare
    tmp_Date DATE;
  begin
    :GLOBAL.TEST_DATE := TO_DATE('01.01.2000','DD.MM.YYYY');     tmp_Date := :GLOBAL.TEST_DATE;
    message(TO_CHAR(tmp_Date,'DD.MM.YYYY'));   end;

I got 01.01.2000 ...

Have a Happy Millennium!

Valeri

pberetta_at_my-deja.com wrote:
>
> 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

<skip>

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru