Conversion between Character fields and Date fields.

[Jerry Niman]

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 NimanTel+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

Re: Conversion between Character fields and Date fields

[Jerry Niman]

Roy,

Thanks, but I already have a work-round - I am looking for support to encourage 
BMC to
provide the functionality as native.

Jerry

Jerry NimanTel+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

 Roy Stark [EMAIL PROTECTED] 07 Mar 08 14:50 
Hi Jerry,

Is it possible to use an external app to do this for you.

Kind regards,
  
Roy Stark
Account Manager
Master Place Ltd
Tel:+44 (0)29 2019-5299
Mobile: +44 (0)773 420-6952
Web:http://www.master-place.co.uk http://www.master-place.co.uk/ 
Any view or opinions expressed are those of the author and do not
necessarily reflect those of Master Place Ltd. This message contains
information which is confidential and is intended solely for the use of
the individual or entity to which this is addressed and is subject to
legal privilege. If you are not the intended recipient, you may not
peruse, use, disseminate, distribute or copy this message. If you have
received this message in error, please notify the sender immediately by
email, facsimile or telephone and return or destroy the original
message. All outgoing messages are scanned by Trend Anti Virus.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are