Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    13

    Unanswered: datediff function

    Hi Gurus

    There is a function in oracle datediff to get the number of days betwen two dates.But someone has crated a function with name "datediff " with different functionality.If i want to use the original datediff function , is there any way other than deleting the user created datediff function.


    thanks in advance
    sai koushal

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: datediff function

    Hi,

    I no know the datedif in DB2, yes in sql.
    You can use this:

    days(date1) - days(date2)


    Abel.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: datediff function

    There is another useful funtion , TIMESTAMPDIFF
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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