Try this: NLS_DATE_FORMAT=Mon DD YYYY HH24:MI:SS
Axton Grams On Wed, Feb 20, 2008 at 10:51 AM, Jerry Niman <[EMAIL PROTECTED]> wrote: > Axton, > > It isn't set at all. > > Where should I set it, and what to? > > 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 > > >>> Axton <[EMAIL PROTECTED]> 20 Feb 08 15:47 >>> > 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" > > > _______________________________________________________________________________ > 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"
