[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 TimeThis 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.