#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    74
    Rep Power
    2

    Time manipulation


    hello, how can i make date manipulations from sysdate in oracle?

    in example subtracting sysdate to a given date and return number of years, months, days, hours?
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    844
    Rep Power
    387

    Cool


    Originally Posted by Kuiva
    hello, how can i make date manipulations from sysdate in oracle?

    in example subtracting sysdate to a given date and return number of years, months, days, hours?
    The answer is clear if you Read The Fine Manual :
    OracleŽ Database SQL Language Reference, section INTERVAL YEAR TO MONTH Data Type
  4. #3
  5. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    844
    Rep Power
    387

    Cool


    [QUOTE=Kuiva]hello, how can i make date manipulations from sysdate in oracle?

    These section contain examples....
    INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND Data Types

IMN logo majestic logo threadwatch logo seochat tools logo