Avoiding time zone confusion in SFMC
Working with time zones in Marketing Cloud, especially in SQL, is not always easy. We have multiple time zones in there, depending on where you look. Here is a good unofficial (compiled in best effort) overview of where which time zone applies: Whenever you need to adjust the time zone in your queries, you need …