Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    40

    Unanswered: Oracle funciton NEW_TIME equvialent in DB2.

    Hi all,

    Is there Oracle new_time function equivalent in DB2 ?

    The new_time function returns a date in time zone1 to a date in time zone2.

    For eg.,

    new_time ( date , zone1, zone2 ) converts time/date in zone1 to zone2.

    Thanks,
    Kamesh.

  2. #2
    Join Date
    Feb 2002
    Location
    Philippines
    Posts
    41
    you need to define a new function for that...

    this site has some UDF like NEW_TIME, NEXT_DAY(), etc.

    http://www7b.software.ibm.com/dmdd/l.../db2/0205udfs/
    There are 10 kinds of people,
    those who know binary and those who don't.

    http://www.linkedin.com/in/rtitong

Posting Permissions

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