What is NLS_DATE_FORMAT set to? Axton Grams
On Wed, Feb 20, 2008 at 10:20 AM, Jerry Niman <[EMAIL PROTECTED]> wrote: > ARS 6.00.03 patch 22 > Oracle 9.2.0.1.0 > Solaris 8 > > I am attempting to set a Date field (not a date/time field) in a SET > FIELDS action within > a filter from the content of a character field on the same form. > > If the character field contains "25/03/07" the date field is correctly set > to 25 March > 2007. > > However if the character field contains "25/03/2007" the date field is set > to 25 March > 2020, ie the filter only sees the first two digits of the year in the > character > representation of the date, and defaults the century to "20". > > the ARDATE environment variable is %d/%m/%Y %H:%M:%S > the ARDATEONLY environment variable is %e %B %Y > > Any ideas? > > Jerry > > > > Jerry Niman Tel +44 (0)161-247 1474 > Head of ICT Services Email [EMAIL PROTECTED] > the Manchester Metropolitan University Mobile +44 (0)7770 638104 > > Before acting on this email or opening any attachments you should read the > Manchester > Metropolitan University's email disclaimer available on its website > http://www.mmu.ac.uk/emaildisclaimer > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
