Results 1 to 6 of 6

Thread: Datatype.

  1. #1
    Join Date
    Jan 2007
    Posts
    5

    Unanswered: Datatype.

    Hi
    I'm new to db2 and i need to
    1. can someone help me in understanding what the below datatype expression.
    2. Use equivalent datatype in ORACLE

    If some one can help me in getting equivalent datatypes in oracle it would be great help.

    a. Decimal( 0, 1, 0 )
    b. DIGITS(YEAR( DW_DATE ))
    c. DATE( calnder_date + 719892)


    Thanks in advance,
    Kanth.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    Quote Originally Posted by bondada_kanth
    a. Decimal( 0, 1, 0 )
    b. DIGITS(YEAR( DW_DATE ))
    c. DATE( calnder_date + 719892)
    not data type, they are functions

    a>decimal (number,precision,scale)
    b> Converts an integer or decimal value into a character string with leading zeros. Both the sign
    indicator and the decimal point are lost in the translation.
    c> date of (calnder_date + no of days )

  3. #3
    Join Date
    Jan 2007
    Posts
    5
    Do someone know equivalent function in oracle.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This redbook should answer this question and more ..

    http://publib-b.boulder.ibm.com/Redb...7048.html?Open

    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2007
    Posts
    5
    document didn't help.

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You should probably ask your question in an Oracle group.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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