Taking care of PST and PDT timezones in datastage
Posted: Thu Jul 19, 2007 10:21 pm
Hi all,
We are currently working in a project for a client in California, and in California PST ( Pacific Standard Time) is followed during winter and PDT(Pacific Daylight Time ) during summer.
We will be running some jobs which will be transform data on Hourly basis.Our business logic is that our mapping columns will change acccording to the time standard being followed. ( for e.g. map Column data from C1 to Z1 from excel file and For long day map Column data from C1 to AA1 from excel sheet).
So we need to know to take care of this switch of time Standard from PST to PDT in our jobs. Is there any patch or any provision in Datastage for this ?
We are currently working in a project for a client in California, and in California PST ( Pacific Standard Time) is followed during winter and PDT(Pacific Daylight Time ) during summer.
We will be running some jobs which will be transform data on Hourly basis.Our business logic is that our mapping columns will change acccording to the time standard being followed. ( for e.g. map Column data from C1 to Z1 from excel file and For long day map Column data from C1 to AA1 from excel sheet).
So we need to know to take care of this switch of time Standard from PST to PDT in our jobs. Is there any patch or any provision in Datastage for this ?