LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: pauldasari

Hello,
I have a date time field coming in as a GMT and would like to convert it to a Eastern date time stamp. Please advise if there is a possibility in doing so. Do not like to hard code for any day light saving time changes.

Thanks in advance!
Paul

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi Paul,

if your datetime field is a string in ISO8601 format with the timezone offset from UTC then you should be able to use the Data Converter node (in the Agg and Transformation category) to turn the data into an unambiguous datetime value. If your field does not have the timezone offset information then the timezone is assumed to be local time - which may not be the correct interpretation. In the attached data flow the Static Data node contains two sets of ISO8601 format datetime values encoded as strings, one with and one without the timezone offset information for GMT (+00:00).

If you look at the output of the Lookup node in the BRE Data Viewer you can see that the converted values for the 'DT' field reflect the local timezone (and daylight saving for records 1, 8 and 9). Since the 'DT_NoZone' record are considered local times the numerical values have not been changed.

GMT_Datetime-Conversions_v2.brg

Regards,
Adrian