February 07, 2018, 11:28 AMRajesh T
[SOLVED] DM : Need to convert timestamps from UTC to Eastern timezone
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,
February 08, 2018, 10:25 AMClif
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.