Dear listers, I have been having an issue where I was trying to read a value from a character field into a date field.
Try as I might, I couldn't get correct behaviour for years in the early part of the century (this was necessary as I was trying to capture dates of birth). I tried setting ARDATEONLY and NLS_DATE_FORMAT but couldn't get it to work. I eventually found a work-round parsing the character string down into day. month and year components, then converting the month to a month number and then using DATEADD to re-assemble the bits into a Date value. However, this is of course less than satisfactory. I am told that BMC do not support converting a Character field into a Date field. Does anyone else think that this would be a REALLY GOOD THING? Can I drum up support for this enhancement? Jerry Jerry Niman Tel +44 (0)161-247 1474 Head of Information and Communication Technology 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"
