InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSun, 07 Sep 2008 00:06:46 GMT20http://www.teradata.com/teradataforum/Topic10997-11-1.aspxI struggled with the same thing, and New_Time only works for US time zones. The following query returns all time zone adjustments, in my case relative to Central Time:select t.*, tz_offset(tzname) offset, sysdate local_time, sysdate + ((to_number(substr(tz_offset(t.tzname), 1, 3)) / 24) - (to_number(substr(tz_offset('US/Central'), 1, 3)) / 24) + (to_number(substr(tz_offset(t.tzname), 1, 1) || substr(tz_offset(t.tzname), 5, 2)) / 1440) - (to_number(substr(tz_offset('US/Central'), 1, 1) || substr(tz_offset('US/Central'), 5, 2)) / 1440)) as tz_time from V$TIMEZONE_NAMES t order by offset, tznameThu, 10 Apr 2008 21:11:53 GMTJimGMIhttp://www.teradata.com/teradataforum/Topic10997-11-1.aspxI am not an expert in Oracle function. I assume you are looking for conversion from one Time Zone to another. Teradata support "AT TIME ZONE"; see "AT TIME ZONE" in "SQL Reference: Functions and Operators" manual. I think it will help you design an expression. For example: select current_time, (current_time AT TIME ZONE interval -'08:00' hour to minute);Fri, 21 Mar 2008 13:22:35 GMTShawhttp://www.teradata.com/teradataforum/Topic10997-11-1.aspxHi Friends,Can we get your kind co-operation sharing knowledge on Equivalent to Oracle's New_Time() function which we require to implement in our migration project in TD.Oracle Function: New_Time('Timestamp',In_Zone,Out_Zone);I appreciate your effort and time finding such valuable solutions & looking forward to get an early response in this regard soon.Thanks... in advance,bbhusan... a TD loverFri, 21 Mar 2008 02:03:03 GMTbbhusan