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
Convert TimeStamp
Moderators: chulett, rschirm, roy
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: