Results 1 to 3 of 3

Thread: DB2 query

  1. 10-03-2007, 04:02 PM #1
    Jayshree
    Jayshree is offline Registered User
    Join Date
    Oct 2007
    Posts
    5

    DB2 query

    select trim(to_char(CURRENT_TIMESTAMP,'MM/YYYY')) from SYSIBM.SYSDUMMY1.

    When I execute this query, I get this error:


    [Star SQL][Star SQL ODBC driver][DB2]THE DATA TYPE,LENGTH OR VALUE OA ARGUMENT 2 OF TO_CHAR IS INVALID.

    Would any one know why??
    Reply With Quote Reply With Quote
  2. 10-04-2007, 12:43 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check db2 syntax in manual.
    Reply With Quote Reply With Quote
  3. 10-05-2007, 06:01 AM #3
    vfr45tgb
    vfr45tgb is offline Registered User
    Join Date
    Oct 2007
    Posts
    1
    SELECT substr(( ADD_MONTHS(CURRENT_TIMESTAMP,6)),4) from SYSIBM.SYSDUMMY1
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules