Date Issue

Question

I have a date column xyz which has the value 'Wed Feb 26 00:00:00 UTC 2020' stored in synapse.How do I convert to EST format in derived column in datafactory pipeline so that it's saved in est format

Answer 1

Hello @Pranvi Kanwar ,

Thank you for posting your query and using MS Q&A platform.

Coordinated Universal Time is 4 hours ahead of Eastern Time. So in below expression I am trying to subtract 4 hours from UTC time zone to get EST. Kindly use below expression in your scenario to accomplish the task.

toTimestamp('Wed Feb 26 00:00:00 UTC 2020','EEE MMM dd HH:mm:ss ZZZ yyyy' , 'UTC')- hours(4)  

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.