Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Select T.[First Name], T.[Last Name], T.Email, dateadd(second,Tz.Time_Difference_in_Seconds_for_SFMC, DATEADD(YEAR,-(DATEDIFF(YEAR, getdate(), DateofBirth)), T.DateofBirth)) as [Local Time], T.DateofBirth, T.Country_code
from [Test Time Record] as T
JOIN [Time Zone] as Tz
on T.Country_code = Tz.Country_code
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment