HI,
I have a source table in which the date is stored in GMT format. I need to convert the GMT format date to EST format(for some months i have to substract 4 hours and for other i have to substract 5 becuase of the day light savings). How can i do it in DS? Please advice .....
How to convert GMT to EST
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
That's not a simple problem to solve properly, hence the suggestion to leverage something else that already does that rather than roll your own solution. You could also do an exact search here for "daylight savings" and see what kind of answers other people got when they had a similar requirement.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Mannual approach would be,
Save the day light saving intervel in a table. Then while extracting from soucre (GMT time) make a look up with this table , then if your daytime fall in the daylight saving intervel then add/substract 4hrs/5hrs else add/substract accordingly. Let me know if this is possible in your case
Save the day light saving intervel in a table. Then while extracting from soucre (GMT time) make a look up with this table , then if your daytime fall in the daylight saving intervel then add/substract 4hrs/5hrs else add/substract accordingly. Let me know if this is possible in your case
Regards,
Sajid KP
Sajid KP