Is there any built in function available in Teradata with similar functionality as FROM_TZ function in Oracle?
Or we will have to do it using INTERVAL or CAST function?
wouldn't it be just a cast?
select cast('2012-12-12 23:12:59+03:00' as timestamp(0) with time zone);
If you need FROM_TZ with two inpurt parameter you could create a SQL udf
where you !! the two input parameter...
REPLACE FUNCTION mydb.FROM_TZ (ts_str char(19),tz_str char(6) )
RETURNS timestamp(0) with time zone
RETURNS NULL ON NULL INPUT
SQL SECURITY DEFINER
COLLATION INVOKER INLINE TYPE 1
CAST((ts_str||tz_str) as timestamp(0) with time zone);
select mydb.FROM_TZ(casT('2012-12-12 23:26:20' as char(19)),cast('-03:00' as char(6)))