UTC to local time of transaction
Hello, All transactions are recorded in UTC time and I would like to transform the dt_email_sent column into the local time, I created a table with all the time zones considering the country and merged with the main table where I have the date that the email was sent. I would like help on which functions to use to add or subtract hours and thus arrive at the local time that the email was sent. I've tried converting to decimals but unfortunately it didn't work. Any thoughts?
