Skip to content

Instantly share code, notes, and snippets.

@naveenvm93

naveenvm93/Merge-Time-Zone-with-Local-Time

Last active April 7, 2020 05:59
Show Gist options
  • Save naveenvm93/9dbff8428d8eb0d09a0ffce29da1fe88 to your computer and use it in GitHub Desktop.
Save naveenvm93/9dbff8428d8eb0d09a0ffce29da1fe88 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Merge-Time-Zone-with-Local-Time
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