Hello All,
I am a bit stuck up at converting a string into timestamp(6) with timezone format in Teradata.
Input String in file : 9/03/2015 7:14AM GMT+01:00
Column in which it needs to be loaded : FG_TSZ TIMESTAMP(6) WITH TIME ZONE 
 
Could someone help me in this ?
 
Thanks,
Nikhil

Hi,

We have Teradata 12 on Linux SLES10 - SP1

When i run the command (several times, for comparision and i removed the timezone info from results):

select current_timestamp(6);

2012-02-21 08:52:00.150000

2012-02-21 08:52:29.600000

2012-02-21 08:52:46.260000

2012-02-21 08:54:24.440000