Hi All
We get the date time from the external system in EST format but would be required to store it in UTC format in the database . How can i achieve this ?
Can the NLS locale be of some help ? Or is there some setting to be done in Datastage to write it in the UTC format.
NLS Locale for storing UTC date time format
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
NLS will be of no help whatsoever. This is an exercise in time zones, not locales. You need to establish the time zone (TZ environment variable) on the server and perform time arithmetic (and perhaps string manipulation) to produce a UTC time.
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.