I have two types of time stamps in my data.
1. Flight Departure Time
2. Session Starttime of Internet Session.
I'd like to find out when the first session on a flight occured. That is pretty simple stuff.
However I have to adjust for time difference. Departure Time is in UTC, Session Start Time in CET
During the spring and summer that a 2 hours differnce, during fall/winter it is 1 hour.
I tried using a when clause, but I get stuck:
This is what I have sofar
WHEN s.[departure_time_UTC] IN (GetMonth(s.[departure_time_UTC])>10 THEN AddMinutes(s.[departure_time_UTC],60)
Has anyone had a similar challenge?
Please sign in to leave a comment.