Focal Point
[SOLVED] DM : Need to convert timestamps from UTC to Eastern timezone

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/4867032986

February 07, 2018, 11:28 AM
Rajesh T
[SOLVED] DM : Need to convert timestamps from UTC to Eastern timezone
Hi

In Data Migrator, is there any function or way to convert a timestamp from UTC to Eastern Standard Time

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
February 08, 2018, 10:25 AM
Clif
Since UTC is five hours ahead of EST you can use the simplified function
DTADD( timestamp , HOUR, -5) 

If you are not using the current release you could use the legacy function HADD.