How to convert GMT to EST

dodda · Post by **dodda** » Fri Aug 21, 2009 10:43 am

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 .....

Sreenivasulu · Post by **Sreenivasulu** » Fri Aug 21, 2009 12:13 pm

Many databases have this inbuilt feature. You can better handle this with database than i datastage

Regards
Sreeni

chulett · Post by **chulett** » Fri Aug 21, 2009 2:04 pm

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.

udayk_2007 · Post by **udayk_2007** » Sun Aug 23, 2009 2:31 am

If you are using Oracle as database,there is a in built function new_time which does the same function

e.g select new_time('15-Mar-09 14:35:00','GMT','EST) from dual;

dodda · Post by **dodda** » Sun Aug 23, 2009 2:41 pm

My base table is an SQL Server ... I need to read it from the SQL Server database ....

ray.wurlod · Post by **ray.wurlod** » Sun Aug 23, 2009 5:47 pm

There should be an OFFSET column in your time dimension table.

sajidkp · Post by **sajidkp** » Mon Aug 24, 2009 1:31 am

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