|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/25/2008 11:36:24 AM
Posts: 5,
Visits: 22
|
|
Hi,
FROM_TZ function in Oracle converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.
In oracle
select from_tz(TIMESTAMP '2008-02-15 01:50:42', '-7:00')
from dual;
will return 15-FEB-08 01:50:42.000000000 AM GMT -07.00
I want to achieve same in TD.
I have tried following in TD
select cast('2005-09-11 13:20:53'||'+03:00' as timestamp with time zone format 'YYYY-MM-DDBHH:MI:SSDS(F)Z')
2005-09-11 13:20:53.000000+03:00
But i want same like in oracle.
Any suggestion will welcome.
Umesh
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2/16/2008 8:59:18 PM
Posts: 1,
Visits: 2
|
|
Hi,
Even i also have almost same requirement.
Please let me know the solution to this.
Thanks,
Kabita
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 4:54:41 PM
Posts: 534,
Visits: 285
|
|
What do you mean by "same like in oracle"?
Exactly the same format? There's only UTC +/- time zone in Teradata, no GMT or EST.
Or something different? It looks like the same answer for me.
Dieter
|
|
|
|