Convert TimeStamp

ram1899 · Post by **ram1899** » 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

kcbland · Post by **kcbland** » Sat Apr 19, 2008 4:26 pm

You're going to need a user written function to add time to a timestamp. Then, you'll just need to pass as arguments to the functions a timestamp and the offset needed.

Your difficulty is dealing with daylight savings time. Even if your timestamp is under daylight savings time, you may have to handle that converting the timezome may run into the odd-handling of that time shift.

Yeah, we hate Benjamin Franklin for this too.

ray.wurlod · Post by **ray.wurlod** » Sat Apr 19, 2008 4:27 pm

This is one you will need to write yourself. What exactly is in the time zone column?