NLS Locale for storing UTC date time format
Posted: Wed Nov 12, 2008 3:20 am
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.
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.