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,
Windows, All Outputs
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.
|Powered by Social Strata|