Convert TimeStamp
Posted: Sat Apr 19, 2008 9:38 am
I have Input file which has a TimeStamp Column , All the values are in ET timezone I want to convert this time stamp to diffrent time zone based on the Local Time Zone Column
My Data in file is
Time in 24 Hrs Clock
Customer Customer_timezone TimeStamp ET
123A ET 2008-04-09 10:20:23
124B CT 2008-04-09 00:10:42
126x PT 2008-04-09 01:30:30
When I convert this timestamp into local time I need output as
123A ET 2008-04-09 10:20:23
124B CT 2008-04-08 23:10:42
126x PT 2008-04-08 10:30:30
Any help on this will be greatly appreciated
Thank you in Advance
My Data in file is
Time in 24 Hrs Clock
Customer Customer_timezone TimeStamp ET
123A ET 2008-04-09 10:20:23
124B CT 2008-04-09 00:10:42
126x PT 2008-04-09 01:30:30
When I convert this timestamp into local time I need output as
123A ET 2008-04-09 10:20:23
124B CT 2008-04-08 23:10:42
126x PT 2008-04-08 10:30:30
Any help on this will be greatly appreciated
Thank you in Advance