Re: Designer Web app and Y2K
From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 23 Sep 1999 08:52:11 -0700
Message-ID: <37EA4CAB.6A0F69F4_at_vnl.nl>
Date: Thu, 23 Sep 1999 08:52:11 -0700
Message-ID: <37EA4CAB.6A0F69F4_at_vnl.nl>
Steve Macmillan wrote:
> I'm developing a web app that has 2 date fields.An activation date and
> an expiration date.When I update either field to the year 2000 it puts
> the year 1900.
How do you know? Did you query the database, or does it show on the web?
> My format mask is DD-MON-RRRR.
Where? In Designer, in the preferences, or on the DB your app runs on?
>
> When I check these fields using PLSQL it tells me 01-JAN-00
Use 'select to_char(your_date_field, 'DD-MON-RRRR') from ...' Bear in mind the Oracle Default date format is still DD-MON-YY!
>
>
> any help would be appreciated
-- Met vriendelijke groet/kind regards, Frank van Bortel Technical consultant Oracle Work: Home: ---------------------------------- ---------------------------- V&L Informatica BV Hunzestraat 4 Palatijn 3, 7521 PN Enschede 7555 WB Hengelo PoBox 545, 7500 AM Enschede (31)074-2425046 053-4341500Received on Thu Sep 23 1999 - 17:52:11 CEST