Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Unanswered: Query On Sysdate

    UPDATE HZ_PARTIES
    SET ATTRIBUTE11 = to_char(add_months(to_date('sysdate','DDMMYYYY'),1 2),
    'DDMMYYYY')
    where PARTY_TYPE = 'ORGANIZATION'
    AND ATTRIBUTE6 ='RUU'

    I CAN'T SEEM TO GET THIS TO WORK, I GET THE ERRORS:

    ORA 01858 A NON NUMERIC CHARACTER WAS FOUND WHERE A NUMERIC WAS EXPECTED

    i have exported the column and I cannot see any illegal characters in the column

    PLEASE HELP,
    Cheers
    Etravels

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    sysdate is already a date.

    PHP Code:
    platform@kod1select sysdate from dual;

    SYSDATE
    =========
    01-APR-04

    Elapsed
    00:00:00.00
    platform
    @kod1edit
    Wrote file afiedt
    .buf

      1
    select add_months(sysdate,2from dual
    platform
    @kod1> /

    ADD_MONTH
    =========
    01-JUN-04

    platform
    @kod1edit
    Wrote file afiedt
    .buf

      1
    select to_char(add_months(sysdate,2),'MMDDYYYY'from dual
    platform
    @kod1> /

    Date_Formated
    ========
    06012004 
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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