Results 1 to 5 of 5

Thread: help on strings

  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Unanswered: help on strings

    Can someone help me on this, I have being stuck onthis for an hour and i have changed the format around and not having any luck!
    Cheers


    1 SELECT p.party_id,
    2 p.attribute2,
    3 p.attribute9,
    4 p.attribute11,
    5 p.attribute7,
    6 ca.account_number,
    7 p.party_name,
    8 p.last_updated_by,
    9 P.LAST_UPDATE_DATE
    10 from hz_cust_accounts ca, hz_parties p
    11 where ca.party_id = p.party_id and
    12 (p.attribute15 <> 'ARC' OR p.attribute15 is null) and
    13 ca.account_number is not null and
    14* to_date(p.attribute9,'DDMMYYYY') + 12 < to_date(p.attribute11, 'DDMMYYYY')
    QL> /
    to_date(p.attribute9,'DDMMYYYY') + 12 < to_date(p.attribute11, 'DDMMYYYY')
    *
    RROR at line 14:
    RA-01858: a non-numeric character was found where a numeric was expected
    Cheers
    Etravels

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: help on strings

    check the columns you are performing operations on.

    Is p.attribute15 a character column
    Are p.attribute9 and p.attribute11 character columns with format DDMMYYYY

  3. #3
    Join Date
    Feb 2004
    Posts
    93

    Re: help on strings

    Originally posted by carloa
    check the columns you are performing operations on.

    Is p.attribute15 a character column
    Are p.attribute9 and p.attribute11 character columns with format DDMMYYYY
    Attribute 9 is a varchar2(150) type
    and so is attribute 11

    how can I change this?

    Cheers
    Cheers
    Etravels

  4. #4
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: help on strings

    What is Attribute15? You are looking for it not to be 'ARC'. If it is a numeric, it could cause the error you are getting.

  5. #5
    Join Date
    Feb 2004
    Posts
    93

    Re: help on strings

    Originally posted by carloa
    What is Attribute15? You are looking for it not to be 'ARC'. If it is a numeric, it could cause the error you are getting.
    thanks but all the attributes are varchar2...none are numeric..

    but they are all date columns!! so i want to make sure they all covert into
    DDMMYYYY FORMAT
    Cheers
    Etravels

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •