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 ?
Taking care of PST and PDT timezones in datastage
Moderators: chulett, rschirm, roy
"Time" contains no notion of time zone, so there is no actual patch possible for this issue. You need to know what your source time location is (Standard) and then use the daylight savings rules for switching between PDT and PST to convert to appropriate "local time".
If your UNIX server is setup correctly, the date command will return the current date, time and timezone so you might be able to use that as a starting point.
If your UNIX server is setup correctly, the date command will return the current date, time and timezone so you might be able to use that as a starting point.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you are using server jobs (which one can assume from the forum in which you posted your question) you can use Oconv() to determine the current time zone.
Code: Select all
Oconv(Date(), "DZ")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.