Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    8

    Unanswered: Casting Float variable as Integer

    Hi,

    My requirement is to cast a Float variable as a integer variable and when i used CAST function for this it encounters error.

    Is it possible in oracle and if so, how ??

    Any help is appreciated ...

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    Use one of the following SQL functions depending on the type of "rounding" you want to perform :

    - ROUND
    - CEIL
    - FLOOR

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

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