NLS Locale for storing UTC date time format

[mouni]

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.

[ray.wurlod]

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.